Hello
I have now ensured that all of my fields do allow zero-length strings (in the MS Access 2000 'Design View' it says 'Yes' next to Allow Zero-Length), yet still have this error message:
Microsoft][ODBC Microsoft Access Driver] Field 'users.fullname' cannot be a zero-length string...
...Access database, store form field values, and close
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Flashform.mdb;"
set rs = Server.CreateObject("ADODB.recordset")
SQL="INSERT INTO users (fullname, email, subject, country...
...Access database, store form field values, and close
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Flashform.mdb;"
set rs = Server.CreateObject("ADODB.recordset")
SQL="INSERT INTO users (fullname, email, country, message) VALUES...
...$message=$_POST['message'];
$name=trim($name);
$email=trim($email);
$subject=StripSlashes($subject);
$message=StripSlashes($message);
/*#########
modify the next line with your own email address
###########*/
$toaddress='myEmail@yahoo.co.uk';
if (preg_match...
Hello Molaker
That's done it!!
I think you have ensured that the cycle involved in inserting the new record does not include the table cell headings, aren't you?
Your finished result is here:
http://stevehigham59.7host.com/w3Test/addShow.asp
Cheers
Steve
Hello Ken
I think I have ruled out the 'submit' button as causing a problem.
I clicked on it and inserted the following:
on (release) {
//Goto Webpage Behavior
getURL("http://www.macromedia.com","_self");
//End Behavior
}
I then uploaded the file, clicked submit and I get taken to the...
Actually, I am trying to send another message to myself, but nothing is coming through. I do not get any server error message which, presumably I would if ther were something wrong with the asp code.
Thanks again.
Steve
Hello Ken
Thank you for your message.
I think I am getting somewhere - slowly.
I have pasted in your script and when not online, Action Script is looking for the flashEmailTest.asp file. Online, I hav completed the 'contact form' I have and clicked 'submit'.
I received an email, meaning that...
That's great, you both. I keep forgetting about the & _.
I saw the table formatting error this morning and have corrected the missing ") so that now I am able to add records to the table:
http://stevehigham59.7host.com/w3Test/addShow.asp
Is there a way of having the table as follows and not...
Hello
I am getting an error message in a page which is supposed to show records in a table:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/w3Test/addShow.asp, line 37
Response.Write("<tr><td>Full...
Hello Ken
If you go here www.graphic9.com you will see a contact form (email.asp). When the site visitor presses submit a copy of it goes to the site visitor himself (HTML formatted), and a copy goes to the Webmaster. The data is also stored in an MS Access database.
This is what my ASP script...
...{
loadVariables ("flashEmailTest.asp", 0, "POST"): void
}
I presume the '0' is the second parameter?
I get the following error message:
**Error** Symbol=Symbol 114, layer=Layer 2, frame=1:Line 2: Syntax error.
loadVariables ("flashEmailTest.asp", 0, "POST"): Void
**Error**...
Hello Ken
Nothing at all happens when I try to send an email. I sent the email mto myself, so I know it has not been received.
This is the VB script I am using:
<%
Dim fullname,email,country,message
if Request.Form("Submit") <> "" then
fullname = Request.Form("a1")
email =...
Hello
I have the following in CSS:
BODY { text-decoration:none; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px
}
However, the link I have on my page is shown as blue underlined, suggesting that I have misplaced the BODY { text-decoration:none;}.
How...
Hello Nickdel
I am happy to answer your questions. I have been involved in Web design for a few years, mainly as a hobby. I have never studied anything related to Web developemnt, IT, Windows, or computers in any academic environment.
I have never focused, either, on ASP/databases, much to my...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.