I get a missing & at " WHERE BreederNo =" & Val(Request.Form("txtBreederNo")), and you'll want to put a space before WHERE
so it should look like
mySQL = "UPDATE Breeders SET PupsAvailable ='" & Request.Form("txtPupsAvailable") & "'"
& "...
I think your DBA will probably want to see something like
set @x = (SELECT @@IDENTITY )
The overhead on this is almost zero.
The set @x = (select max(RecordID) from Table1) if you have a very large table, or a large number of records, will get quite timely, but will be just as effective on...
okay, to redirect to a document, you have to tell the server what type it is first, by using Response.ContentType.
In playing with it, this seemed to open all of my documents.
Response.ContentType = "application/word"
Thanks to all
Tom
I don't have the luxury of hard coding it in. There may be from 1 to 100's of documents in the directory I am building the list from. I need to create a link to a document, be it Word, Excel or Powerpoint, log that the document was opened, and display it to the user.
Does that clear up any...
Is there a way to Response.Redirect to a document (mydoc.doc)? I can create a link to the doc and it opens just fine. But when I try to redirect to it all I get is binary garbage.
aValues(2) = "Mydoc_in_a_special_directory.ppt"
...
page =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.