VBScript variables into fp generated sql statement (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


Guest -> VBScript variables into fp generated sql statement (8/1/2001 13:45:00)

I have a form that passes information to another form. In the second form I have the DRW insert the data into the table. (i have this working)

my problem is that I also have the second form calculating a couple values and i also want to add tehm to the table.

I can edit the asp file manually and get it to work. I was wondering if any one knows how to do it in the DRW in custom query.

Here is what i need

INSERT INTO tblMediaData (MediaType) VALUES ('"&MediaType&"')

Here is what FP gives me

INSERT INTO tblMediaData (MediaType) VALUES ('""&MediaType&""')

I dont need the other set of double quotes.
Any Ideas or suggestions?

Thanks,
Bill





Spooky -> RE: VBScript variables into fp generated sql statement (8/1/2001 16:43:00)

MediaType needs to be valid DRW syntax, which is ::MediaType::

To do it with asp, you need to put the code on a diet.

www.outfront.net/spooky/adv_drw_diet.htm

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625