Skip to main content
J
jenn1
Inspiring
July 15, 2009
Question

How can I insert the values of a string intact

  • July 15, 2009
  • 3 replies
  • 909 views

I need to insert the following string into a table:  1517 Electronics, Photonics, and Device Technologies (EPDT). What gets inserted instead is

1517 Electronics

Photonics

and Device Technologies (EPDT).

myString=1517 Electronics, Photonics, and Device Technologies (EPDT).

I'v used #PreserveSingleQuotes(myString)#

Any ideas as to what I'm dong wrong?

This topic has been closed for replies.

3 replies

A
Anonymous
July 16, 2009

You can just embed the string in quotes and pass to the function in the following link which will return it in Array. You can then insert it to db. Please refer

http://cflib.org/udf/CSVtoArray

C
craigkaminsky
Inspiring
July 15, 2009

Hi, Jenn,

Can you post a bit more of the code related to your issue? As Dan mentioned, the string may well be acting as a list or, and along those same lines, it could be something with your SQL/Insert code but it's kind of tough to tell (for sure) without a little more code/details.

D
Dan_Bracuk
Inspiring
July 15, 2009

Somehow you are treating your string as a comma delimited list.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices