Search results for query: *

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.

Does anybody have experience with server performance or stability by NOT setting references to DLL objects in ASP to nothing? Yours, Rob.

Although the following is not appreciated by the server in terms of performance, you can also use the following: myvar = request(&quot;form_variable_name&quot;) The default property is to scan all collections (.form, .querystring, .cookies etc) for the given named argument.. (It's a...

Try using: WHERE rowid='AAAAsPAADAABHLcAAM' or rowid='AAAAsPAADAABHLeAAB' or rowid='AAAAsPAADAABHLeAAC' etc.. Yours, Rob.

You can also use the RTrim and LTrim functions of Sql Server to remove the extraneus spaces: sql = &quot;SELECT * &quot; &_ &quot;FROM vacrequest &quot; &_ &quot;WHERE LTrim(RTrim(department)) = '&quot; _ & reqdeptsearch & &quot;' &quot; &_ &quot;AND...

Look a http://www.4guysfromrolla.com/webtech/031401-1.shtml for a discussion about using the Locale Identifier in ASP. Yours, Rob.