ohgosh

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 these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group …

[CODE]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 [/CODE] what does the error actually means when it refers me to [I]line 0[/I]? whereby i cant figure out where the main problem lies..

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 default value. wad shd i do? is there any mtd to get d value selected? THANK …

HI~ i have a series of checkbox with different names, how do i validate them? validate to check that one of the checkbox must be checked in order to save the changes in the current page. [U]here are my checkbox codings[/U] [CODE]<input type="checkbox" name="stud" value="yes">Student <input type="checkbox" name="lect" value="yes">Lecturer <input …

hi there.. can i retrieve the break tag from querystring? i have a textarea which i store in a querystring. the textarea will not show the break tag if i have break tag among the text i typed. let me explain in greater details. i have a dropdownlist whereby onclick …

Hi peeps... A good day to all of you yea~ as i know, i can retrieve only the first row by using the keyword [B]limit 1[/B]: [CODE]select * from tblTesting limit 1[/CODE] for selecting the first two rows are: [CODE]select * from tblTesting [B]limit 2[/B][/CODE] is there any solution to …

hi all, do anyone knows how to create a dynamic dropdownlist? the dropdownlist will retrieve the list items from database.. eg: below is code for static dropdownlist where i declare the listitem myself.. but how should i declare listitem retreive from database? [CODE] <asp:dropdownlist id="ddl" Runat="server"> <asp:ListItem Value="1">A</asp:ListItem> <asp:ListItem Value="2">B</asp:ListItem> …

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, then i check if the recordset is eof and bof then i will …

hi there, i am doing asp.net and had many sets of checkbox which is html checkbox and not asp checkbox. eg: [CODE]<input type="checkbox" id="chkbox11" value="1" onclick="javascript: checkcheck(this);" runat="server"> <input type="checkbox" id="chkbox12" value="2" onclick="javascript: checkcheck(this);" runat="server"> <input type="checkbox" id="chkbox13" value="3" onclick="javascript: checkcheck(this);" runat="server"> <input type="checkbox" id="chkbox14" value="4" onclick="javascript: checkcheck(this);" runat="server"> <input …

hi all, a 'space' in asp.net is '&nbsp', how about 'tab' in asp.net? by the way, can i [B]add image to a listbox user control? [/B] if so, please provide the codes or any ref links.. [COLOR=DarkRed]a million thanks![/COLOR]

i m getting the error as Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /myweb/updat.asp, line 18, column 181 my code is <% if session("bvuser")="true" then struser=request("usercode") stremail=request("email") strfname=request("fname") strlname=request("lname") straddress=request("address") straddress1=request("address2") straddress2=request("address3") strcity=request("city") strcountry=request("country") strpassword=request("password") struser=session("usercode") dim rsupdat,Conn,sql Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Driver={MySql ODBC 3.51 Driver}; …

Hi there, i have question on arranging columns whereby the datatype is date and time how should i arrange them so that the latest date & time entry will be in the first row? i have a table displaying records and these records' columns are retrieved from 3 different tables …

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 these 2 sql statements below. [CODE]sql1 = "select distinct * from t_staff group …

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. [CODE]<% sqlUser= "select distinct * from t_user_type order by userType" set rsUser = conn.execute(sqlUser) do while not rsUser.eof sqlView = "select …

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 date/time [U]only [/U] when i click the button. is it possible? i think …

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 and take in the selected products details and the order quantity and then …

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~ [CODE]Error Type: Microsoft VBScript runtime (0x800A01C9) This key is already associated with an element of this collection [B]Loader.asp, line …

i wud like to select records which userStatus' values is sth. ive gt a tbl with a userStatus column, dis column is stored with statusID and the values in dis column, userStatus, are either numbers or nothing inside. now i wud like to retrieve the userStatus which values are sth …