Hello everyone,
I am trying to issue a simple insert statement and it is giving me an error.
The SQL statement is:
<cfquery name="q_savebk" datasource="home">
insert into web.bookmark(ulocation, desc)
values ('#URLEncodedFormat(form.f_ulocation)#','#form.f_desc#')
</cfquery>
Value of form.f_ulocation is : http://www.macromedia.com
Value of form.f_desc is : Macromedia website
The platform is: Linux Redhat 7.3/MX Pro/MySQL
Below is the error message from the Server (BTW, I tried the above in my NT
server and it works.).
Thank you in advance,
Percy
---
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax near
'desc) values ('http%3A%2F%2Fwww%2Emacromedia%2Ecom%2F','Macromedia
Website')' at line 1
The error occurred in /home/www/developer/bookmarks/test_save.cfm: line 14
12 : values
13 : ('#URLEncodedFormat(form.f_ulocation)#','#form.f_desc#')
14 : </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
