Search results for query: *

nice, I will try the DSNless and see if that works better. It is access databases, both of them...so we will see. bb

Here is the code I am using...i do set the sessoin on the pages in a different include...so i should leave the session part out, right? Sub Application_OnStart() Application("DB_CONNECTION_STRING") = "DSN=HIPPA" Application("DB_CONNECTION_LOGIN") =...

ok, so I tried the method: You need to change you variable names for the second connection.... Sub Application_OnStart() Application("DB_CONNECTION_STRING") = "DSN=HIPPA" Application("DB_CONNECTION_LOGIN") = "hippa&quot...

ok, it's the string2 i didn't didn't rename...i left it as string, because the rest i had changed...thanks..i will try it and let you know how it works... bb

I am only setting the session and such. Below is what I have, but I want to use it for two databases...it works currnently as is.. <SCRIPT LANGUAGE=&quot;VBScript&quot; RUNAT=&quot;Server&quot;> Sub Application_OnStart() 'Application(&quot;DB_CONNECTION_STRING&quot;) =...

I tried putting two on one page and that didn't work...both pages ignore the file. bb

I have two databases running off of the same site, and i need to use two global.asa's. since this is not possible, can I put both connections in one file? I did try just merging the two and that did not work, is there another way to do this? bb

Okay, the Javascript I am posting is HORENDOUSLY LONG because it is checking for many things within the date, but the issue is this: When I put a date in the date field that falls within the min/max year, it submits fine, but it pops up the box sayin &quot;you need to enter the day in dd...

I have this code for my buttons: <FORM ACTION=&quot;ReportData_test2.asp&quot; METHOD=&quot;POST&quot; NAME=&quot;RW&quot;> <INPUT TYPE=&quot;hidden&quot; NAME=&quot;PageNo&quot; VALUE=&quot;1&quot;> <FONT FACE=&quot;Verdana, Arial, Helvetica, Sans Serif&quot; SIZE=&quot;2&quot;> <INPUT...

I would like to be able to add on specific headers, that are choosen prior to the search results being given; here is my paging results code AND FOLLOWING IS HOW I AM SPECIFYING HEADERS...andy suggestions on how to intergrate?: Do While Not rs.EOF If j > 20 Then ' -- Output a new table for...

But the issue is I also need to compare the field LASTUPDATE from both tables. I only want to insert in the JCAHO_CROSSWALK table any records that have agency_id 6 and have been updated since the last upload. bb

NEVERMIND....BRAIN LAPSE FOR A MINUTE bb

INSERTED gives me an invalid name error....any other suggestions (this is in SQL 2000) bb

I am trying to set up a DTS package to run every day. What needs to happen is it need to check on table for any updated records with an AGENCY_ID of 6 from the REPORT TALBE against TEMP table. If the LASTUPDATE fields do not match, then a new copy of the record needs to be appended to the TEMP...

I have been trying this statement: SELECT * FROM REPORT WHERE AGENCY_ID = 6 From ther I want to input into a duplicate table. How can I do this? I have tried several ways...but no luck. Thanks! bb

When I click on the links for any of the pages, instead of going to the next recordset, it requeries the entire database which is over 15000 records. It does not carry over to teh next 10 results. This is the code on the page. <%@ LANGUAGE=&quot;VBSCRIPT&quot; %> <% 'Option Explicit %> <%...

When I click on the links for any of the pages, instead of going to the next recordset, it requeries the entire database which is over 15000 records. It does not carry over to teh next 10 results. bb

This is the code on the page. <%@ LANGUAGE=&quot;VBSCRIPT&quot; %> <% 'Option Explicit %> <% Response.Buffer=TRUE 'Turn Buffering on Response.Expires = -1 'Page expires immediately 'Constants Const MIN_PAGESIZE = 5 'Minimum pagesize Const MAX_PAGESIZE = 20 'Maximum pagesize Const...