navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

VBScript variables into fp generated sql statement

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> VBScript variables into fp generated sql statement
Page: [1]
 
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

 

Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
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


(in reply to Guest)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> VBScript variables into fp generated sql statement
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts