|
| |
|
|
cwc56
Posts: 38
Joined: 1/12/2002
From:
Status: offline
 |
update query and stored procedurers - 5/8/2002 11:44:36
This is two questions really.
1. Is it possible to connect to an update querry in an access database using frontpage and if it is how is it done?
2. Is it possible to connect to a stored procedure held in a module within an access database using frontpage and if it is how is it doen?
If both are possible within frontpage, which is easier?
Many Thanks
Chris
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: update query and stored procedurers - 5/8/2002 17:24:53
Both afaik are no. The Access query wont accept parameters.
Has anyone tested and found otherwise?
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
cwc56
Posts: 38
Joined: 1/12/2002
From:
Status: offline
|
RE: update query and stored procedurers - 5/9/2002 11:57:34
Many thanks for your reply.
If I were to move away from FP and write in asp, ado, VBscript could I then connect to an update query?
I suppose what I am asking is; is it a function of FP that is stopping me, or is it a function of .asp itself? If I were to go and write my own ADO connections and SQL statements could I then connect and pass parameters to an update query in an Access database?
Or am I simply trying to do something which is impossible in .asp?
Many Thanks
Chris
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: update query and stored procedurers - 5/9/2002 18:13:24
What I mean, is that its a problem with Access. Update queries are afaik an Access function.
A stored procedure can be used for updates in SQL as you can pass parameters.
Any updates you do, will need to be via the custom SQL button of the DRW. This uses an SQL string to perform the update (not a procedure)
eg : "UPDATE table SET coolumn='::input::'"
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
cwc56
Posts: 38
Joined: 1/12/2002
From:
Status: offline
|
RE: update query and stored procedurers - 5/13/2002 9:30:31
Many thanks
Got it.
Chris
| |
|
 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
|
|
|
Printable Version 
