Insert to Database

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Insert to Database

Logged in as: Guest

arrSession:exec spGetSession 2,2,288

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Insert to Database
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Insert to Database - 7/23/2001 10:27:30 PM

ckc

Posts: 1
Score: 0
Joined: 7/23/2001
From: Malaysia
Status: offline

can someone tell me why this is not working
<%
sub insert_record
q_insert = "insert into Master(requestedBy,requestDate,currency,expiredDate) values ('1','2/2/2001','US','3/2/2010')"
if Submit <> "" then
sql_execute(q_insert)
InsertMsg
else
BlankrecError
end if
end sub
%>

whenever i use the sub procudure it cannot work but if i just put the code inside without using the procedure it can inside to the database