I finally figured it out. I had the name of one of the fields from the form set wrong...but all your comments helped also. Thanks!!
-Jake --- Steve Oliver <[EMAIL PROTECTED]> wrote: > Ah good point, I bet that's the problem. > > Rename date, and get rid of the quotes around your > integers, and all > should work. > > ______________________ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -----Original Message----- > From: Cody Estes [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 10:18 PM > To: CF-Talk > Subject: RE: Foreign keys > > > Why not rename your date field to something else instead > of "date". > Isn't that a reserved word? > > Cody > > ::: -----Original Message----- > ::: From: Jake Munson [mailto:[EMAIL PROTECTED]] > ::: Sent: Wednesday, February 20, 2002 8:39 PM > ::: To: CF-Talk > ::: Subject: RE: Foreign keys > ::: > ::: > ::: Nope, I tried your code with no luck, and I also > tried > ::: just removing the quotes (#form.date#, etc...) > ::: > ::: Any other suggestions? > ::: > ::: -Jake > ::: --- Darryl Lyons <[EMAIL PROTECTED]> > wrote: > ::: > Remove the quotes around the date (preferably use > VALUES > ::: > (#CreateODBCDate(form.date)#,#techs.id#,etc...) > ::: > > ::: > Darryl > ::: > > ::: > -----Original Message----- > ::: > From: Jake Munson [mailto:[EMAIL PROTECTED]] > ::: > Sent: Thursday, 21 February 2002 8:53 AM > ::: > To: CF-Talk > ::: > Subject: RE: Foreign keys > ::: > > ::: > > ::: > Thanks for the reply. > ::: > > ::: > I tried that, and I still got an error with this > query: > ::: "Syntax error > ::: > in INSERT INTO statement. The error occurred while > ::: > processing an element with a general identifier of > ::: > (CFQUERY)..." > ::: > > ::: > I know that this table exists in my ODBC source, > and that > ::: > the column names match what I have in the query. > ::: > > ::: > -Jake > ::: > > ::: > --- Steve Oliver <[EMAIL PROTECTED]> > wrote: > ::: > > If the ID's are integers, you don't want to put > quotes > ::: around them. > ::: > > > ::: > > <CFQUERY NAME="AddLogEntry" DATASOURCE="Software > ::: > > Updates"> > ::: > > INSERT INTO log (date, tech, software, > comments) > ::: > > VALUES ('#form.date#', #techs.id#, > #software.id#, > ::: > > '#form.comments#') > ::: > > </CFQUERY> > ::: > > > ::: > > ______________________ > ::: > > steve oliver > ::: > > atnet solutions, inc. > ::: > > http://www.atnetsolutions.com > ::: > > > ::: > > > ::: > > -----Original Message----- > ::: > > From: Jake Munson [mailto:[EMAIL PROTECTED]] > ::: > > Sent: Tuesday, February 19, 2002 7:38 PM > ::: > > To: CF-Talk > ::: > > Subject: Foreign keys > ::: > > > ::: > > > ::: > > Hi guys, > ::: > > > ::: > > How can I insert the id field of a query into > another > ::: table? What I > ::: > > am wanting is to use the id from one > ::: > table > ::: > > as a foreign key in another table. To do this, > I run > ::: a query on the > ::: > > two tables, and then I want to insert the > ::: > primary keys > ::: > > (field named id) from these two tables as > foreign keys > ::: > in the second > ::: > > table. > ::: > > > ::: > > Below is the code I have written that ins't > working. > ::: > > > ::: > > <cfquery datasource="Software Updates" > name="techs"> > ::: > > SELECT * > ::: > > FROM techs > ::: > > WHERE tech='#form.tech#' > ::: > > </cfquery> > ::: > > <cfquery datasource="Software Updates" > ::: > name="software"> > ::: > > SELECT * > ::: > > FROM software > ::: > > WHERE software='#form.software#' > ::: > > </cfquery> > ::: > > <CFQUERY NAME="AddLogEntry" DATASOURCE="Software > ::: > > Updates"> > ::: > > INSERT INTO log (date, tech, software, > comments) > ::: > > VALUES ('#form.date#', '#techs.id#', > '#software.id#', > ::: > > '#form.comments#') > ::: > > </CFQUERY> > ::: > > > ::: > > Thanks. > ::: > > > ::: > > -Jake > ::: > > > ::: > > > __________________________________________________ > ::: > > Do You Yahoo!? > ::: > > Yahoo! Sports - Coverage of the 2002 Olympic > Games > ::: > > > ::: > > > ::: > > ::: > > ::: > > ::: > ::: > ___________________________________________________________ > ::: ___________ > ::: Dedicated Windows 2000 Server > ::: PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER > ::: Instant Activation . $99/Month . Free Setup > ::: > http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona > ::: FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > ::: Archives: > http://www.mail-archive.com/[email protected]/ > ::: Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists > ::: > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
