Recent content by stemitch2000

Hello people, Please can you help me? I have a text box, but do not wish the user to be able to paste into the text box. They are allowed to write in it - but not paste into it. Anyone know how I go about doing this? I suppose I could see if the first key pressed is a ctrl, but is there a...

Hi, I have a basic form, with some field as radio buttons. How do I give focus to a radio button once the user has pressed submit and the radio button is not checked (i.e. the user has not agreed with the terms and conditions). thank you Steven

hello I haven't used LDAP much - and have only used it to search. but this is how I searched through it. sSQL = "Select AdsPath FROM 'LDAP://server-name/dc=pass,dc=com' where objectclass='Person' and id='" & id & "' and sn='" & surname & "' and givenName='" & firstname & "' ORDER BY cn" Set...

Hello, I have got a column of cells, with numbers in them. I would like to generate just one cell with this numbers seperate by a comma. i.e. 10 2 3 4 would end up like 10, 2, 3, 4 This is to go into a comparison table, and nothing to do with CSV - though that is an option.

Hello I am writing a script to change the current live database so that is it conpatible with the new system, when it goes live. A few fields have been added, so I need to insert some columns in the tables. How do I go about doing this?

to be absolutely correct then it might be best to put dName = UCase(CStr(Request.ServerVariables("REMOTE_USER"))) instead of dName = UCase(CStr(Request("REMOTE_USER"))) just incase you create another variable called "REMOTE_USER"

try something on the line like this dName = UCase(CStr(Request("REMOTE_USER"))) i = InStr(1,dName,"\") + 1 dName = Mid(dName,i) Response.Write "User is " & dName should do the trick

Ok I have a database on a server, and the system I am updating requires the connection to be client side, so that the client can move on the recordset, update, delete, etc with out having to refresh the page. Any ideas how I archieve this?

ok guys, I found the solution the openDB = con needed to be set openDB = con then it worked for that pages, now I have to figure out how to fix the other pages

Yeah any ideas would be greatful - I am in the similar situation - just I have moved servers.

Still get the same error the function is this, added error handling in it. function OpenDB dim con On Error Resume Next err.clear If session("con")="" Then response.write "opening new connection" Set con =...

I have a function that sets up a connection to a database. function OpenDB dim con On Error Resume Next If Not (IsObject(con)) Then response.write "opening new connection" Set con = Server.CreateObject("ADODB.Connection") set session("con") = con strDSN =...

another question, when I am making a call to the function above, do I call it like this? set con = OpenDB() or is this syntaxly incorrect?

Could I put my code to set up the connection in the following place? If session(&quot;con&quot;)=&quot;&quot; Then 'open e new connection. <<code>> set session(&quot;con&quot;)= con end if 'if it's alreadey opened then start using it set con=session(&quot;con&quot;)

It doesn't as such - but the first error checking bit does produce the error, so I think it is something to do with the Set con = Server.CreateObject(&quot;ADODB.Connection&quot;) set session(&quot;con&quot;) = con since the last post I commented out the set con = session(&quot;con&quot;)...