Search results for query: *

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

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

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

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

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

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

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

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

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

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

'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...

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

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

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

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!

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

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