Question
UUID-based confirmation works locally, not online
Hi everyone,
So here's the deal. I've created the standard 'confirm my email address' deal using UUIDs. When I try the code using my local CF install, it works like a charm. The email is generated, I click on the link, and the email address is confirmed in my database. When I upload the code to my webserver, the fun begins:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'emaillist_uuid = 9C2926C9-EAD5-25FB-0BE4A223D324F9BD'.
The error occurred in E:\user\mydomain.ca\email.confirm.cfm: line 38
36 : <cfquery name="confirm" datasource="wcg">
37 : SELECT * FROM emailReg
38 : WHERE emaillist_uuid = #URL.UUID#
39 : </cfquery>
I have no idea why it's giving me a syntax error. I'm a newbie coder, but the whole 'now I work, now I don't' thing is driving me crazy.
The link in the email looks like this:
<a href=" http://www.mydomain.ca/email.confirm.cfm?UUID=#URLEncodedFormat(emaillist_uuid)#">http://www.mydomain.ca/email.confirm.cfm?UUID=#URLEncodedFormat(emaillist_uuid)#</a>
and my confirm query like this:
<!--- UUID query to confirm and update email records --->
<cfquery name="confirm" datasource="wcg">
SELECT * FROM emailReg
WHERE emaillist_uuid = #URL.UUID#
</cfquery>
Why would it give this error? Let me know if you need more details. I've tried dropping the URLencoded deal, I've added single (') and double (") quotes around the #URL.UUID# in my where statement, all with similar results. If I wrap the #URL.UUID# in single quotes, it can't even find the UUID in my table (though it's there - I check). Blargh!
Thanks a pile, everyone. Looking forward to figuring this out.
Text
So here's the deal. I've created the standard 'confirm my email address' deal using UUIDs. When I try the code using my local CF install, it works like a charm. The email is generated, I click on the link, and the email address is confirmed in my database. When I upload the code to my webserver, the fun begins:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'emaillist_uuid = 9C2926C9-EAD5-25FB-0BE4A223D324F9BD'.
The error occurred in E:\user\mydomain.ca\email.confirm.cfm: line 38
36 : <cfquery name="confirm" datasource="wcg">
37 : SELECT * FROM emailReg
38 : WHERE emaillist_uuid = #URL.UUID#
39 : </cfquery>
I have no idea why it's giving me a syntax error. I'm a newbie coder, but the whole 'now I work, now I don't' thing is driving me crazy.
The link in the email looks like this:
<a href=" http://www.mydomain.ca/email.confirm.cfm?UUID=#URLEncodedFormat(emaillist_uuid)#">http://www.mydomain.ca/email.confirm.cfm?UUID=#URLEncodedFormat(emaillist_uuid)#</a>
and my confirm query like this:
<!--- UUID query to confirm and update email records --->
<cfquery name="confirm" datasource="wcg">
SELECT * FROM emailReg
WHERE emaillist_uuid = #URL.UUID#
</cfquery>
Why would it give this error? Let me know if you need more details. I've tried dropping the URLencoded deal, I've added single (') and double (") quotes around the #URL.UUID# in my where statement, all with similar results. If I wrap the #URL.UUID# in single quotes, it can't even find the UUID in my table (though it's there - I check). Blargh!
Thanks a pile, everyone. Looking forward to figuring this out.
Text
AdChoices