Recent content by ryandoah

lol. thanks.

Yeah, it kills the query. Server: Msg 195, Level 15, State 10, Line 3 'SCOPE_IDENTITY' is not a recognized function name.

Thank you. Though I contest that Scope_Identity() will work in SQL7, as reference above. And, yes, I tested it. No dice. @@IDENTITY, on the other hand, does work.

Because Leigh had just made the suggestion as an answer to my question, which means Leigh was probably still online, which means I MIGHT be able to get an answer to my next question before she/he logs back out, which I didn't, but it's a chance worth taking, huh? The first response I received...

Do you know if this method is SQL 7 friendly?

Excellent, that's the kickstart I needed. I've googled this and found that it is not SQLServer 7 compatible, which is a problem, but it's a start.

Does anyone know how or if it is possible to return the primary key of a newly inserted record at execution? Thank you, ryandoah

lol, We all know the feeling. Keep familiar with the FSO stuff, though, it can be quite handy from time to time.

Yeah, it's just allowing anon users to DL the source. At this point, I'd say your code is not the problem.

With the two corrections (the opening " and closing -->) the code should run fine. Does it still crap out with the corrected code? If so, are you sure you have the relative paths correctly listed? Personally, I use virtual directories, which allows me to avoid many of the path resolution...

Like asked on the JS forum, why not just provide a direct link to the file, instead of all the fso stuff. Such as: <A href="rc_consumerproposal.doc">Consumer Download</a> Are you trying to achieve something like the file can only be downloaded by particular types of users, ie; Business or...

Also, one last thing. The file name reference for the CreateTextFile method should be a fully qualified path.

what I did to fix this problem that has plagued me for days? dim fso, createFile Set fso = server.CreateObject("Scripting.FileSystemObject") Set createFile = fso.CreateTextFile("testfile.txt", TRUE) createFile.writeLine(strTop + strTitle + strBody + strBottom) createFile.close I changed the...

Upon your request for the code, it made me think to reexamine the code. At this point, I must disclaimer that I did NOT write the original code for this script. It was written by one of my supervisors, who's job description doesn't entail coding, but had code some COBAL back in the day, so...

Yeah, I checked both, both are set to read & write. The NTFS on the directories themselves are currently set to Everyone(modify). I also tried to explicitly define the individual NT logon name permissions with no luck either. Everything seems like it should be, but still get the permission...