let say I have one combo box and one text box! The value in combo box are retrive from ms sql database! When I have already selected one of the value in the combo box! How I float the related value which need to retrive from the same database and same table to the text box?
Please give me...
I'm using SQL server 2000 and Windows XP! I facing this problem when I try to connect to my database!
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection...
I was using SQL Server 7 previously, and change to SQL Server 2000! I found some problem within my ASP page with the connection to SQL Server 2000
The error came out is:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'HPMSF23\IUSR_HPMSF23'.
Can Anyone just give me...
I have created a database that store certain value and date as well at the same time! How do I get record set which is before certain date?
Please give me a hand!
Thanks for your kindness!!
I using asp to get time value and store in SQL server!
The problem I get is, the data I get save into SQL is like this 1/1/1900 1:30:56 am!
How do I get only the time value to save in SQL?
I got a code like this! How do I change the width for the textbox? Please...
Response.Write "<td><input name=service_id value="&rs("service_id")&" readonly></td>" & vbCrLf
Thanks in advance!!!
I got some data like this
ID Name Email
10 Tan tan@abc.com
10 Lee lee@pqr.com
10 Chong chong@mnp.com
I want to display the ID one only in other place.
How to write the query to get the ID for only once?
I'm writing a page, can I have 2 different submit button? S that when I click on the different button, the form will submit into different page?
Can anyone give me some guide, is quite urgent!
I try to do some security function in my asp page to allow only certain computer(by checking the hostname) to acess my page... But I don't know how to get the hostname...
Or do you all got other better suggestion to do that?
Please give me a hand...I need to complete this things very soon...
I have a function that can add row in a table...
Can anyone here help me to figure out how to delete a row?
my coding is like this:
function addTableRow(tableName)
{
totalTableRow = totalTableRow + 1
var newRow;
var newCell;
var currentRow;
currentRow = totalTableRow
//...
I've tried to do something like below so that I can do the insert procedure to save a few sets of data into the database from a multirow table... Can anyone here please help to have a look what's wrong it it?!
dim number, counter
counter = 0
number=Request.Form("count")
Do until...
I try to do something looping so that I can get a few of records to store in my database with multirow table...
Can anyone here please help check for it!?
This is my code:
dim number, counter
counter = 0
number=Request.Form("count")
Do until counter = number
counter = counter +...
I have store several data including date into the database...The date format that I'm using is 4/26/2002! How do I can get the data set with the condition is the latest date???
Hope that are anyone to give me a hand...!
I try to write a query to insert the data by the conditionis the latest date but can't work...
Can someone give me a hand?
the code that I've write is like :
SQL ="UPDATE tracking SET c_name='"&c_name&"', c_email='"&c_email&"' WHERE equip_id='"&equip_id&"'...
I try to get a maximum value from a columm and my coding is like that:
SQL= "SELECT max(service_id) FROM tracking "
set rs = openConn.Execute(SQL)
dim id
id=rs("service_id")
Response.Write(id)
but it still got error! The error is:
ADODB.Recordset (0x800A0CC1)
Item...
I wanted to pass a values which is a integer to asp page so that I will know how many records that I have to run the insert queries... Can any one please give me a hand?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.