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!

Register Log in
  • Congratulations derfloh 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: *

  1. Skee777

    DTS export limits to 255 characters

    Hello, I have a DTS that exports an SQL table to a text file. One of the values of the table is a remarks column. I have set the column up as a varchar/1000. When I view the data in the table, all the data is there. When I export the data using the Microsoft text driver ODBC, the data gets...
  2. Skee777

    Clearing Request.ServerVariables("LOGON_USER")

    Thanks Falcon for your input. When a user opens a new IE browser session and accesses our secure website, client for microsoft networks prompts them to login. If the user were to close the browser or open a new browser session, they would be prompted to login again. In this situation, I am...
  3. Skee777

    Clearing Request.ServerVariables("LOGON_USER")

    Hello, I have a secure site using nt authentication. In one instance I would like to open a new window from a link. I have this worked out, but the user authentication session carries over to the new window. I would like to force a new login request when the window is opened. I am using the...
  4. Skee777

    SQL2000 Remote Connection Can't find server

    Hello, I am running MSDE for SQL2000 on a windows2000 server. I am trying to connect to this server from a client using the Enterprise Manager or through ODBC. When I try to register the server in the client/remote EM using the server name, I get an error message "specified sql server...
  5. Skee777

    NT4 losing passwords on reboot

    Hello, I have an nt4 server this is losing passwords on system reboot. Specifically it is loosing the sa password for the sql2000 server and the odbc password for pervasive. It appears that these settings are in the registy and for some reason on a system restart, the passwords get lost. To...
  6. Skee777

    IIS services keep stopping

    Hello, Wondering if anyone knows why our IIS services keep stopping, you reboot the box or start the service again and all is well until 5 or 10 even 900 minutes later and it happens again. I am running nt4 with iis4. I also recently installed an email package called mailmaxweb from...
  7. Skee777

    Send Search Results to another Asp Page

    Try sending your link to another asp page that runs the query. <a href='query.asp?companynumber=&quot; & RS(&quot;companynumber&quot;) & &quot;'> text here </a>&quot; Where RS(&quot;companynumber') is, insert your company number from your record set Pass this to a new asp page that runs...
  8. Skee777

    Need Sleep

    I use a function like this to delay the script 'Timed delay to allow for posting to database' Dim StartTime, EndTime, WaitTime ' Get Start Time' StartTime = Timer() 'Get End Time' EndTime = Timer() 'Determine how long it took' WaitTime = EndTime - StartTime 'Continue checking the elapsed...
  9. Skee777

    Quotation Marks in SQL Statement

    Thanks essnrv, Unfortunatly it produced the same error. I did find someone that said to use &quot;&quot; like this. strSQL = &quot;SELECT * FROM Transaction, &quot;&quot;Unit-Participator&quot;&quot; WHERE Transaction.T_TRAN_NUMBER = &quot;&quot;Unit-Participator&quot;&quot;.U_TRAN_NUMBER...
  10. Skee777

    Quotation Marks in SQL Statement

    Hello, Can someone help me with this problem. I have a SQL statement that looks like this; strSQL = &quot;SELECT * FROM Transaction, &quot;Unit-Participator&quot; WHERE Transaction.T_TRAN_NUMBER = &quot;Unit-Participator&quot;.U_TRAN_NUMBER AND ((Transaction.T_MLS_NUMBER='990616'))&quot; The...
  11. Skee777

    How to parse numeric sql query result with commas

    'Create SQL statement that will count distinct offices' strSQL = &quot;SELECT COUNT(Distinct OfficeNumber) AS ubound FROM DataPorts WHERE OfficeNumber <> ''&quot; 'Create SQL statement and return only unique office numbers using group by' strSQL2 = &quot;SELECT OfficeNumber FROM DataPorts...
  12. Skee777

    How to parse numeric sql query result with commas

    Gorkem, Thanks for the suggestion. The problem is that my query result is returned like this. (1 12 34 4 17) without the spaces so it really comes out like (11234417). What I need to do is parse the result with commas like (1,12,34,4,17). I believe that the split function would remove the...
  13. Skee777

    How to parse numeric sql query result with commas

    I am trying to create a comma delimited array from an sql query result. I use a count query to create the ubound on my array, but the actual query is a select group by. The results are returned as one long number. If I loop through the record set using Response.write, I can concantinate the...
  14. Skee777

    Removing null characters from SQL char values

    I screwed up. I created a SQL table with char fields. Now when I try to post the data from the SQL table to an access table, it has null characters padding the data. I tried to trim the records, but the characters are not actually spaces. I tried to figure out how to use the replace function...
  15. Skee777

    help with form verification

    Thank you so much. Your explaination was very thorough and very helpful. I hadn't considered the fact that the S1 value would always be true. Your assistance us very appreciated!
  16. Skee777

    help with form verification

    I am trying to validate a form using javascript. The form has two submit buttons. If the first button is clicked, the form should run a brief verification, then change the form action to an asp page. If the second button is clicked, the for will run the verification, then change the form...
  17. Skee777

    Perform Multi-Record Updates with a Single Submit

    Is there an easy way that to perform a multi-record update using a single submit in ASP? Basically I have a form that is created using a query. It is built by bringing back multiple records as text boxes. I then what to change the information on a few of the text boxes and click submit to...

Part and Inventory Search

Back
Top