COMMA MADNESS

[100dtl]

Hi

I'm trying to get a comma before the 300000 but with little sucess, any ideaas?

arrData(intCount) = "'300000"&Trim(arrData(intCount))&"' or sku like '*"&Trim(arrData(intCount))&"' or sku ="

 

[mwolf00]

are you trying to format the number???

a = 300000

response.write formatNumber(a,0,0,0,1)

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[100dtl]

No, I'm doing update statements and need the ' before the 30000

 

[mwolf00]

OK - so you need a comma? or a single quote?


arrData(intCount) = ",'300000"&Trim(arrData(intCount))&"' or sku like '*"&Trim(arrData(intCount))&"' or sku ="


I'm confused - can you post what you need it to look like when it's done?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)