Recent content by RobV

Try select [SEQ_TABNAME].currval AS [IDNAME] from dual instead of INTO Bye, Rob.

thanks for replying, dragon. Is this operation multithread safe? I mean: Am I sure that that is the correct value given to the record? Or is there a possibility with multiple inserts that I'm getting an incorrect value, given the fact that the connection is only used for the insert of one...

I'm experienced with SQL server 7 and Access, but not with Oracle, and I need to do some maintenance on an Oracle 8i server. I stumbled across a problem: A particular table has an insert trigger so that new ID's are being generated by a sequence at insert. However, after insert, that key cannot...

I'm experienced with SQL server 7 and Access, but not with Oracle, and I need to do some maintenance on an Oracle 8i server. I stumbled across a problem: A particular table has an insert trigger so that new ID's are being generated by a sequence at insert. However, after insert, that key cannot...

I need to implement drag & drop of nodes in a treeview. I got the loading and displaying of the tree working, but I cannot seem to get the drag & drop on the webpage working. I need to drag&drop nodes inside the tree, and I need to drag & drop items from another listbox to a given position the...

Hi, This is a helpful tip I wanted to share with you. Please let me know if you like it. Sometimes you have a situation where you cannot always be sure that your DB connection is being closed (e.g. in case of a error or simply lazy coding). If you ASP site is running VBScript 5.1 or later (I...

First of all, excuse me for misposting (I didn't want to reply, but start a new thread instead) Thank you mrTom, although I doesn't really help me. I DID see a tutorial somewhere where the showed you how to 'group' all names (e.g. distinct lastnames), but thats as far as I got. I hope this...

Can anybody explain to me how to group a xsl:for-each statement? e.g. <PERSONS> <PERSON> <NAME>John</NAME> <EXTENSION>232</EXTENSION </PERSON> <PERSON> <NAME>Mary</NAME> <EXTENSION>122</EXTENSION </PERSON> <PERSON> <NAME>James</NAME>...

You could do this using JavaScript; just submit to page to itself (just refresh it or whatever and spit out some javascript) (remember, this just pseudocode) <% if request.form(&quot;submit&quot;) <> &quot;&quot; then 'process submit here session(&quot;name&quot;) =...

A good practice is to escape the arguments for your SQL statements so that the code doesn't crash when you substitute special characters in the argument. E.g. sql = sql & &quot;Firstname LIKE '&quot; & Replace(request.form(&quot;txtFirstName&quot;), &quot;'&quot;, &quot;''&quot;) &...

I know of an ASP-only piece of VBScript which interprets the file upload submit, but doesn't require a custom component on the server. Here's the URL: http://www.asp101.com/resources/visitors/index.asp?page=2 Yours, Rob.

Yes, it is. <FORM method=&quot;POST&quot; action=&quot;result.asp&quot; target=&quot;_blank&quot;> I don't know if this works for all browsers, but at least IE5 understands it. Yours, Rob.

(Oops; reply instead of post) Yours, Rob.

I'm wondering how to merge html fragments and layout using XSLT. Say I have a XML file containing an HTML fragment: <root> <fragment> <B>test</B> </fragment> </root> BTW, I need to build this XML using the DOM. And an XSLT: <xsl:stylesheet...

Aye, but we have a lot of legacy code where that was not a common practise. I just wanted to know if it was necessary to revise all the code. Yours, Rob.