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

    Can a global.asa set two db connections?

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

    Can a global.asa set two db connections?

    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") =...
  3. bberrios

    Can a global.asa set two db connections?

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

    Can a global.asa set two db connections?

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

    Can a global.asa set two db connections?

    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;) =...
  6. bberrios

    Can a global.asa set two db connections?

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

    Can a global.asa set two db connections?

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

    CheckDate Error

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

    Fixing Javascript Buttons

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

    Adding Headers to Paging Results

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

    DTS UPDATE ERROR

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

    DTS UPDATE ERROR

    NEVERMIND....BRAIN LAPSE FOR A MINUTE bb
  13. bberrios

    DTS UPDATE ERROR

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

    DTS UPDATE ERROR

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

    Select data to INSERT into another table.

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

    Paging issue - carrying over query results

    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 %> <%...
  17. bberrios

    Paging Links not carrying over query results

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

    Paging Links not carrying over query results

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

Part and Inventory Search

Back
Top