Thank you, �-------------- Kicking selfs ass so that I start paying attention more
�--------------- thanks a lot.. >>> [EMAIL PROTECTED] 01/31/02 04:54PM >>> I am shooting in the dark here .. could the ' quotes around it be giv ing you fits? Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > This is frustrating. I am checking to make sure a value is numeric when I use NOt isnumeric it runs through the query and it accepts letters. If I take it away it won't go through the query. Almost like its backward s. Plus it thinks of numbers and letters are the same. Am I doing somet hing wrong? > > <CFSET STEP = '1'> > <CFLOOP INDEX="ITEMINDEX" LIST="#LIST_Q#"> > <CFSET T = #LISTGETAT(q, variables.step)#> > <CFIF not isNumeric('t') > > <CFQUERY NAME="U_CART" DATASOURCE="xxxx"> > <CFIF #LISTGETAT(q, variables.step)# IS 0> > DELETE > FROM tblshopping_cart > WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX# > <CFELSE> > UPDATE tblshopping_cart > SET QUANTITY_S = '#LISTGETAT(Q, variables.STEP)#' > WHERE SHOPPING_IDNUMBER_S = #ITEMINDEX# > </CFIF> > </CFQUERY> > <CFELSE> > <CFLOCATION URL="somewhere.cfm" ADDTOKEN="NO"> > </CFIF> > <CFSET STEP = '#STEP#' + 1> > </CFLOOP> > _____________________________________________________________________ _ 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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
