was it bcos of ur concatenation?

sql="update users1 set email='" & stremail & "' and fname='" & strfname & "' and lname='" & strlname & "' and address='" & straddress & "' and address1='" &...

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.

/test.asp, line 0

what does the error...

i know where the problem lies in my error yea~ cos of typo error at tt line it's complaining:

set rsIn = conn.execute(strIn)

it should be :

set rsIn = conn.execute(sqlIn)

Hi there,

i got a question on asp recordset.. i got a page whereby i will display records from a particular table. first i will go & do a select sql command to retrieve records from database,...

didn't i paste my sql statemt during my very 1st post?

sql1 = "select distinct * from t_staff group by staff"
sql2 = "select distinct * from t_staff order by staff"

btw ive used group by and...

huh wad do u mean? i try using order by, but error occured on the page. i dont understand wad happen so i had to use another method to resolve.

wad u mean by aggregrate similar entries? do u mean pick up oli distinct records? do it mean different if i remove distinct from select statement?

but i can still display my dropdownlist value in...

oops :x sorry i think i post this thread to the wrong forum..

see ya guys in the forum under databases. hope to hear from you soon.

Hi there,

wanna ask if the sql syntax order by and group by the same?
eg: i have a dropdownlist and the values displayed should be in ascending order. hence is there any difference if i use...

;) huh?!? im using asp not asp.net.. i dun quite understand wad are u tryin 2 link me to.. haha~ would u prefer to explain more.. cheers~

heiya.. thanks william_stam!! saw so many of your replies & am grateful.. seems that you're quite pro in programmin ar?

anyw.. i use diff way to store my checkbox n the checking of the checkboxes...

:cool: thanks for the help.. i mng to get the current time.. n here, im going to share with u guys..

my solution is neither using javascript nor refresh page.. it is that:

i get the current...

do u have any link for those javascript?

how do i get the current date/time when i click a button? i manage to retrieve the value of current date/time in 2 separate hidden fields when the page loads.. but i want to retrieve the actual...

do u mean this:

<%
i = 0
varcount = 0
sqlUser= "select * from t_user_type order by userType"
set rsUser = conn.execute(sqlUser)

do while not rsUser.eof
i =...

so how should i do? any improvement on d code u could provide in here? sorry to bother u..



what do u mean? could u explain furthermore? thanks~

HI there,

i haf a series of dynamic checkbox retrieved from db. I can display my checkbox successfully but now i cant get more than one checkbox being checked.

<%
sqlUser= "select...

Hi there...

I have a page showing products records and there is a checkbox and textfield to enter order quantity for each record. When i click on the Add btn, it will check for the checked records...

:?: what do u mean? i dont get it.. could you explain further more? or give any example.. honestly, i don't know how the loader page works.. :rolleyes:

i came across this error and i dont seem to understand what actually cause the error to occur.. Can anyone explain the error if you know or have any idea.. THANKS~

Error Type:
Microsoft VBScript...

wad do u mean? i dun quite understand.. do u mind sharing n tellin me more?

it wud b great to even provide some eg. hEE~

real thanks... :cheesy:

ive a dynamic dropdownlist, which items are retrieved frm db. but when i select an item from the dropdownlist, the item does not stay selected instead the dropdownlist make a postback and stay as...