Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-27 : 12:12:46
|
Amer Ali Mirza writes "How can I combine the code from two pages into one ?
First Page:
Listsql="Select ID, Tip_Title, Tip_Text, Type, Current_Start_Date, Current_End_Date, Current_Scheduled_By, Created_By, Created_Date from Tips"
rsList.Open Listsql, kcCONNECTSTRINGVALUE
Second Page:
Listsql="INSERT INTO Tips (Tip_Title, Tip_Text, Type, Current_Start_Date, Current_End_Date, Current_Scheduled_By, Created_By, Created_Date) VALUES ('"&txtTitle1&"', '"&txtText1&"', '"&txtTipTopic1&"', '"&txtStartDate1&"', '"&txtEndDate1&"', '"&txtUser1&"', '"&txtUser1&"', '"&txtDate&"')"
rsList.Open Listsql, kcCONNECTSTRINGVALUE
Thanks" |
|
|
|
|
|
|
|
Combining two Queries in ADODB