Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: choohean
  • Content: Threads
  • Order by date
  1. choohean

    need help in on_change event with sql

    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...
  2. choohean

    Not associated with a trusted SQL Server connection. HELP

    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...
  3. choohean

    Login failed

    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...
  4. choohean

    How Do I get record set for before certain date

    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!!
  5. choohean

    Can I Draw A table within the Textarea?

    I was tried to draw a table and display some data with a textarea, is it possible??
  6. choohean

    Date problem

    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?
  7. choohean

    How Do I only Allow certain pc to access my page

    I have created some asp page! How do I only allow certain pc to access my asp page within the intranet?
  8. choohean

    Is it possible, generate monthly and daily email reports?

    I was doing a system and I have to send email to some personal for daily and also monthly reports! It is possible to do this by asp???
  9. choohean

    How to change the lenght!

    I got a code like this! How do I change the width for the textbox? Please... Response.Write &quot;<td><input name=service_id value=&quot;&rs(&quot;service_id&quot;)&&quot; readonly></td>&quot; & vbCrLf Thanks in advance!!!
  10. choohean

    How to display the data once!

    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?
  11. choohean

    Is it possible to have 2 submit button in a form? Urgetn!

    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!
  12. choohean

    is there anyway to have a msgbox in ASP page?

    As I know that ASP page cannot call out a msgbox... Is there any way to do this???
  13. choohean

    How to get client-side hostname...Urgent... Please....

    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...
  14. choohean

    how to do the function for the delete row???

    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 //...
  15. choohean

    How to do looping with array..

    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(&quot;count&quot;) Do until...
  16. choohean

    Looping... can help to check for it?

    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(&quot;count&quot;) Do until counter = number counter = counter +...
  17. choohean

    how to get latest date data set!

    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...!
  18. choohean

    what is the query to look for latest date?

    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 =&quot;UPDATE tracking SET c_name='&quot;&c_name&&quot;', c_email='&quot;&c_email&&quot;' WHERE equip_id='&quot;&equip_id&&quot;'...
  19. choohean

    how to get the maximum value?

    I try to get a maximum value from a columm and my coding is like that: SQL= &quot;SELECT max(service_id) FROM tracking &quot; set rs = openConn.Execute(SQL) dim id id=rs(&quot;service_id&quot;) Response.Write(id) but it still got error! The error is: ADODB.Recordset (0x800A0CC1) Item...
  20. choohean

    how to pass values to asp page?

    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?

Part and Inventory Search

Back
Top