How to type cast ' and , in Spufi while inserting records

vaibhav_pal · New User Joined: 20 Jan 2007 Posts: 4 Location: Mumbai

Hi,

I am trying to insert records thru spufi. The data which I want to insert has got ' and , in it. However I am not able to insert the data because either it treats it as end of data for the field or continuation to next field.Is there any way to typecast the single quote(') and comma(,) in spufi insert statement?

vaibhav_pal · New User Joined: 20 Jan 2007 Posts: 4 Location: Mumbai

For Example
INSERT INTO SAMPLETBL VALUES ('ER3,'xyz abc' time')

I am not able to insert the record with the , and ' in the data.

Can anyone provide help on it?

Gnanas SNG · Posted: Wed Mar 19, 2008 3:47 pm Post subject:

Here values for how many columns are inserted?

Say,

Two columns,

col1 value - ER3
col2 value - xyz abc' time

dbzTHEdinosauer · Posted: Wed Mar 19, 2008 4:10 pm Post subject:

for two columns:

Gnanas SNG · Posted: Wed Mar 19, 2008 4:16 pm Post subject:

You have to put one more quote if the value contains a qoute.

To insert this,

vaibhav_pal · New User Joined: 20 Jan 2007 Posts: 4 Location: Mumbai

It worked with extra quote.
The problem was with the ' symbol and not comma.
Works fine now.
Thanks for all the help.