Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
tb5821 #1
Error Help
There is a drop down list box on my site where you select the option you want
then click go only when you click go I get this...???
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/srch_weave_result.asp, line 63
tb5821 Guest
-
Error Message "A drawing error ocurrred which is probably due to an out-of-memory condition. Try qu
I am running Acrobat Reader 5.0 on a Mac Powerbook running OS 9.2 and keep getting "A drawing error occurred which is probably due to an out of... -
Error 403 Failed to read heders Error for long-runningCFMAIL and CFINDEX command
I have two different pages with long-running scripts on which I am recieving the following error: Error - 403 Failed to read headers to server:... -
Error Creating Control: Parser Error DocHeader does not have a property named 'cc3:MyItems'
I am having problems getting this webcontrol working properly. Everything else works fine except having items. So here is the low-down on the... -
Unexpected error. A trappable error (C0000005) occurred in an external object.
Hi Elvin, After doing some reseaarch on this problem, I found there is a lot of issues which may cause the problem, for example, incorrect access... -
An error occurred while try to load the string resources (GetModuleHandle failed with error -2147023888)
Hello, on one of our customers servers we get following error on first ASPX-page: An error occurred while try to load the string resources... -
mab_bellamy@yahoo.co.uk #2 Error help
i am new to cold fusion, and using dreamweaver to help me make my site. I have
created a login form, and have now just created a register form. The register
form just inserts a record into my database which is access. But when i load
the page and get an error:
Error Executing Database Query.
Syntax error in INSERT INTO statement.
The error occurred in C:\CFusionMX7\wwwroot\marks\register.cfm: line 21
19 : <cfelse>
20 : NULL
21 : </cfif>
22 : )
23 : </cfquery>
The line it refers to is the last cfif tag, anyone know what the problem is?
Thanks for any help
mab_bellamy@yahoo.co.uk Guest
-
-
mab_bellamy@yahoo.co.uk #4 Re: Error help
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">
<cfquery datasource="marks">
INSERT INTO Customers (Username, Password, EmailAddress) VALUES (
<cfif IsDefined("FORM.username") AND #FORM.username# NEQ "">
'#FORM.username#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
'#FORM.password#'
<cfelse>
NULL
</cfif>
,
<cfif IsDefined("FORM.email") AND #FORM.email# NEQ "">
'#FORM.email#'
<cfelse>
NULL
</cfif>
)
</cfquery>
<cflocation url="index.cfm">
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
color: #000000;
font-weight: bold;
font-size: 16px;
}
-->
</style>
</head>
<body>
<div align="center" class="style1">
<p>Register</p>
<form action="<cfoutput>#CurrentPage#</cfoutput>" name="form1" method="POST">
<p>Username:
<input name="username" type="text" id="username">
</p>
<p>Password:
<input name="password" type="password" id="password">
</p>
<p>FirstName:
<input name="first_name" type="text" id="first_name">
</p>
<p>Surname:
<input name="surname" type="text" id="surname">
</p>
<p>E-mail:
<input name="email" type="text" id="email">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>
<p> </p>
<input type="hidden" name="MM_InsertRecord" value="form1">
</form>
<p> </p>
</div>
</body>
</html>
mab_bellamy@yahoo.co.uk Guest
-
mxstu #5 Re: Error help
"Password" may be reserved word in your database. Try changing the column name
to say "UserPassword" or putting square brackets around the column name in the
INSERT
INSERT INTO Customers (Username, [Password], EmailAddress) .....
mxstu Guest
-
mab_bellamy@yahoo.co.uk #6 Re: Error help
there is no error with that, if you read the error above, it shows that the error is with the lsy cfif tag for some strange reason. Anyone any ideas?
mab_bellamy@yahoo.co.uk Guest
-
mxstu #7 Re: Error help
Did you try it? There does not appear to be anything wrong with the syntax and
that is the error message you would see if your were using the unicode access
driver. "Password" is a reserved word using that driver.
mxstu Guest
-
mab_bellamy@yahoo.co.uk #8 Re: Error help
thanks, that was correct, just changed the password to user.password and yip pee it worked fine. Thanks m8t
mab_bellamy@yahoo.co.uk Guest
-
mab_bellamy@yahoo.co.uk #9 Re: Error help
wait, if i submit the form i get the same error again
mab_bellamy@yahoo.co.uk Guest
-
mxstu #10 Re: Error help
You're still referencing the "Password" column. You need to change that.
mxstu Guest
-
mab_bellamy@yahoo.co.uk #11 Re: Error help
nope, changed everything to userpassword. Could this be something to do with access unicode? how can i install an access database with out this unicode as when i try it fails!
mab_bellamy@yahoo.co.uk Guest
-
mxstu #12 Re: Error help
Well looking at the error message, it wasn't changed. Are you sure you saved
your changes?
SQL INSERT INTO Customers (Username, Password, EmailAddress) VALUES ( 'test' ,
'test' , 'test@test.com' )
DATASOURCE marks
VENDORERRORCODE 3092
SQLSTATE
mxstu Guest
-
mab_bellamy@yahoo.co.uk #13 Re: Error help
LOL, am an idiot lol. Yer u were correct, i put brackets round and it worked strait away. Well soz for waisting you time again, lol. Thanks any ways.
(i will be back again)
mab_bellamy@yahoo.co.uk Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
