artist_ID and album_ID should be integers and therefore should not require single quotes around the values (and if they aren't integers...they should be changed)
Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 1:37 PM Subject: Why wont this insert > I have this query that does an insert, (or suppose to) and I cannot for > the life of me figure out why. I have done a <CFDUMP> on the variables > to make sure everthing is showing up and it outputs fine but nothing > gets inserted. Does anyone see a problem here? > > <CFQUERY DATASOURCE="cmg" NAME="get_max_albumID"> > SELECT MAX(ID) AS album_ID > FROM albums > </CFQUERY> > > <CFQUERY DATASOURCE="cmg" NAME="insert_titles"> > DECLARE @maxid int > BEGIN > SELECT @maxid = MAX(ID) > FROM titles > IF @maxid = NULL > SELECT @maxid = 1 > ELSE > SELECT @maxid = @maxid + 1 > END > > > INSERT INTO titles ( ID, > artist_ID, > album_ID, > SG1, > SG2, > SG3, > SG4, > SG5, > SG6, > SG7, > SG8, > SG9, > SG10, > SG11, > SG12, > SG13, > SG14, > CP1, > CP2, > CP3, > CP4, > CP5, > CP6, > CP7, > CP8, > CP9, > CP10, > CP11, > CP12, > CP13, > CP14 ) > > VALUES ( @maxid, > '#artist_ID#', > '#get_max_albumID.album_ID#', > '#capFirstTitle(SG1)#', > '#capFirstTitle(SG2)#', > '#capFirstTitle(SG3)#', > '#capFirstTitle(SG4)#', > '#capFirstTitle(SG5)#', > '#capFirstTitle(SG6)#', > '#capFirstTitle(SG7)#', > '#capFirstTitle(SG8)#', > '#capFirstTitle(SG9)#', > '#capFirstTitle(SG10)#', > '#capFirstTitle(SG11)#', > '#capFirstTitle(SG12)#', > '#capFirstTitle(SG13)#', > '#capFirstTitle(SG14)#', > '#CP1#', > '#CP2#', > '#CP3#', > '#CP4#', > '#CP5#', > '#CP6#', > '#CP7#', > '#CP8#', > '#CP9#', > '#CP10#', > '#CP11#', > '#CP12#', > '#CP13#', > '#CP14#' ) > > </CFQUERY> > > > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > ______________________________________________________________________ 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
