No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
18 Posted Topics
 | 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 ' ', 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] |
| | was it bcos of ur concatenation? sql="update users1 set email='" & stremail & "' and fname='" & strfname & "' and lname='" & strlname & "' and address='" & straddress & "' and address1='" & straddress1 & "' and address2='" & straddress2 & "' and city='" & strcity & "' … |
| | 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 … |
The End.