I'm kinda stumped on this problem I've been having:
[excerpt from dspPatInsertConfirm.cfm]
<cfset tabName="pat">
<cfset cols="(pid, mcn, foundry, package, dieconfig, productid,
project_alias, technology, sirev, user_comment, username, flag)">
<cfset
vals="sq_pat.nextval,#mcn_id#,#foundry#,#package#,#dieconfig#,#productid#,#project_alias#,#technology#,#sirev#,'#comment#',1,0">
<cfinclude template="actInsertToTable.cfm">
[excerpt from actInsertToTable.cfm]
<cfquery datasource="#app.dsname#" name="insert_#tabName#">
insert into tab_#tabName# #cols# values (#vals#)
</cfquery>
This is basically a generic means of inserting values into tables. I have
this working for table that only have numeric values. It seems to choke on
the comment field above which is a string. Here is the error message I get:
ODBC Error Code = S1000 (General error)
[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-00917: missing comma
SQL = "insert into tab_pat (pid, mcn, foundry, package, dieconfig,
productid, project_alias, technology, sirev, user_comment, username, flag)
values (sq_pat.nextval,9,2,2,2,1,1,2,1,''I AM EDITED COPYlkjk'',1,0)"
I tried cutting and pasting that SQL into a command line and it appears
that the quotes around the "I AM EDITED COPYlkjk" is actually two single
quotes in series rather than double quotes. it gave an error on the
commandline. When I removed the extra single quote it worked on the command
line. I'm not sure how to fix this. I thought maybe that the sql statement
was inserting extra single quotes for the string, but when i took them out
in dspPatInsertConfirm.cfm it choked again. Any ideas on how to fix this?
Has anyone been able to successfully create a generic insert script?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
