Search results for query: *

hi, is possible 2 display auto number just after the record is added and updated. I mean for example, it display recorded is added and auto number for this field is "auto number"

hi everyone thanks for help, my prog is working. I has spaces in front of records in the database, which i was trying to get, cause i had (' "&clName& " ')spaces between the colons & speech marks instead of ('"&clName& "')in my INSERT method. thanks

hi i have problem with updating an existing record, i get the folloing error mess. My database has 6-7 records. Its working with other functionality Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current...

still the same problem

still the same error mess,

no there about 6-7 records in my_table

i tried response.write(userName) cause in varible i have N cap

no

i have records in the database & i tried what u told me but dint work Error Type: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /cw1/withdraw_money2222.asp, line 18 Browser Type: Mozilla/4.0...

ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /cw1/withdraw_money2222.asp, line 18 line 18 is balance = RS("cl_balance")

<% userName =Request(&quot;name&quot;) dim sql set myCon =Server.CreateObject(&quot;ADODB.Connection&quot;) myCon.open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&quot; & server.mappath(&quot;client_details.mdb&quot;) Set RS = Server.CreateObject(&quot;ADODB.RecordSet&quot;)...

i posted my code again if u like 2 look at it again thanks

next error Error Type: ADODB.Recordset (0x800A0E79) Operation is not allowed when the object is open. /cw1/withdraw_money2222.asp, line 18 RS.Open ,myCon,adOpenStatic,adLockOptimistic, adCmdTable

I am sorry new error mess Microsoft VBScript compilation (0x800A0409) Unterminated string constant /cw1/withdraw_money2222.asp, line 16, column 84 rs.open &quot;SELECT cl_balance FROM my_table WHERE cl_name =' &quot;&userName &&quot; ',myCon,1,3...

hi i get this error mess this time Microsoft VBScript compilation (0x800A0401) Expected end of statement /cw1/withdraw_money2222.asp, line 16, column 75 rs.open =&quot;SELECT cl_balance FROM my_table WHERE cl_name =' &quot;&userName &&quot;'&quot;,myCon,1,3...

do u have any suggestions about this? thanks 4 ur help

if i type in RS.Open sql ,myCon,adOpenStatic,adLockOptimistic, adCmdTable i still get same error

hi i get this message when i made changes Error Type: ADODB.Recordset (0x800A0E79) Operation is not allowed when the object is open. /cw1/withdraw_money.asp, line 22 line 22 is: RS.Open sql , myCon, adLockOptimistic

hi I get this error message in withdraw_money.asp, plz someone help thanks in advance here are the error details Error Type: Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'Update' withdraw_money.asp, line 30 here is my code: ================== <%...