Recent content by bberrios

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