Database Transfer Using VBScript

[PulsaMatt]

Hi, I Am looking to try to convert the data that is in a current database into the new structure I designed for Version 3 of the application I am building.

I have been trying to write simple VB scripts to do the conversion for me, but they keep crashing at odd points due to some issues (namely in Version 1 people could use single quotes in a comment field, in version 2 you couldn't but you could use double quotes in a comment field) so both field delimiters that I know of ' and " are out of the question .... any ideas on how I Can do this?

For the most part its a straight old field to new field conversion but there are a couple fields where I need to combine and reorder data to make the new field (The results of me learning this as I go along).

Any help is GREATLY appreciated .

Matt Laski
Sysadmin, Pulsafeeder Inc.

 

[hithere]

check out this link and see if that helps.

http://www.devguru.com/Technologies/vbscript/quickref/replace.html

mb

"Where's the Ka-Boom? There's supposed to be an Earth-shattering Ka-Boom!"
Marvin the Martian

 

[PulsaMatt]

I'm trying the replace statement from that link using this line

comments = replace(comments,"'","_",1,1,1)

and I get an ASP error of an invalid use of null in the replace command ... is it due to the ' being the string to replace?

Matt Laski
Sysadmin, Pulsafeeder Inc.

 

[PulsaMatt]

I tried running the same thing using:

comments = replace(comments,"t","t",1,1,1)

and I get the same error.

I know comments isnt blank because in the code before that I check for an empty comments field and insert "No Comments Added" in its place ... so thats not it ... *scratches head*

Matt Laski
Sysadmin, Pulsafeeder Inc.

 

[jonscott8]

How did you &quot;check for an empty comments field&quot;? I'm presuming by If comments <> &quot;&quot; Then....

FYI. NULL <> EMPTY <> &quot;&quot;

Try If IsNull(comments) Then comments = &quot;...&quot;


Jon Hawkins