stored query

[DotNetGnat]

Hi guys,

I have a stored query in Access that works fine...

PARAMETERS qrystr text(255)
Select * from mytable WHERE myfield = qrystr

but i tried to do something similar for the update statement...

PARAMETERS qrytstr text(255), id int
UPDATE mytable
set myfield = qrtystr
WHERE recid = id

and it does not work...any suggestions...

-DNG

 

[dhookom]

You haven't told us what or why you are attempting to run an update. Where do you expect ID and qrytstr come from?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[DotNetGnat]

i would call the stored query from my asp page...

sql = "exec mystoredquery '"&qrystr&"',"&id&" "
con.execute(sql)

-DNG

 

[DotNetGnat]

fixed it...thanks guys...

-DNG