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 Chriss Miller 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: *

  • Users: Bigced21
  • Order by date
  1. Bigced21

    Trying to link scanned pics to a tbl in db????

    I understand. the field that is being added will contain the filename or url of the image. My problem is I don't no how to link to the image, that's the process i want to learn. Programming language I'm using is ASP, and the fields in the table are id, fname, lname, ssn, date_birth...
  2. Bigced21

    Trying to link scanned pics to a tbl in db????

    the naming convention we came up with for the images are lastname, first initial, and last 4 digits of ssn. The reason why, b/c some individual can hold more than one kind of license, for ex., plbing, electrical, boiler. and that's exactly what I want to do is pass around filenames, but it...
  3. Bigced21

    Trying to link scanned pics to a tbl in db????

    Fair enough!! i have pics stored on a file server. I'm doing a license renewal process and want to insert pics on there renewal licenses. There records are in a sql server db that I have printed there original licenses from, but now that its time for renewals, we want there pics displayed as...
  4. Bigced21

    Trying to link scanned pics to a tbl in db????

    How then Esquared? I'm dying to see examples, but make sure you read my reply to SQLSister response.
  5. Bigced21

    Trying to link scanned pics to a tbl in db????

    SQLSister, Now the images also need to be linked to a record possibly multiple records. Is that possible?
  6. Bigced21

    Trying to link scanned pics to a tbl in db????

    The reason why I ask this is b/c i'm adding another feature to a current prog., which are pics. Is it possible to link scanned pics from a file server to an existing table with a created field for the pics to be linked to its file name on SQL server?
  7. Bigced21

    Having trouble querying a specific date

    Ok, John76 that worked!! Thanks!! and thank you too leighmoore!!!!
  8. Bigced21

    Having trouble querying a specific date

    I'm using sql server 2000. What I'm trying to do is write a select statement to query all records with a date of 6-14-2004, and I'm not getting any results. Could someone please give me some ideas. In access it's easy as hell, but this is throwing me in a loop right now. the data type for the...
  9. Bigced21

    Need help w/Operation is not allowed when the object is closed

    CHOPSTICK.....YOU DA MAN!!!!!!!!!!!!!!! THANKS A BUNCH AS WELL AS THE REST OF YOU HAVE HELPED ME WITH THIS PROBLEM. YOU ALL ARE THE BEST!!!!
  10. Bigced21

    Need help w/Operation is not allowed when the object is closed

    chopstick name is non-numeric, and Fees_Paid_total is null when i run the query analzyer
  11. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Chopstick your code returned a -1
  12. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Ok, something new I added to my sp - I added SET ANSI_WARNINGS OFF and I received a new error: Microsoft VBScript runtime error '800a000d' Type mismatch: 'formatNumber' /boilers/blr_report_county_totals.asp, line 44 Here is line 44(look for >>>>>) i = 0 Do while NOT rs.EOF If i Mod 2 = 0...
  13. Bigced21

    Need help w/Operation is not allowed when the object is closed

    although it runs in query analyzer????
  14. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Chopstick & shaddow neither one of those worked. I'm hella stumped!!!!!!
  15. Bigced21

    Need help w/Operation is not allowed when the object is closed

    no it's right because I have other pages using sp's and they work just fine. I'm probably missing something small b/c i've tried just about everything and I can't come to a conclusion as to why I'm getting this error
  16. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Line 35 is the Do while not rs1.EOF. It won't run on my ASP page but works perfectly in Query Analyzer. this is the error I get: ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. Do while NOT rs1.EOF If i Mod 2 = 0 then...
  17. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Nope, still getting the same error
  18. Bigced21

    Need help w/Operation is not allowed when the object is closed

    No
  19. Bigced21

    Need help w/Operation is not allowed when the object is closed

    ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. /boilers/blr_report_county_totals.asp, line 35 Do while NOT rs1.EOF If i Mod 2 = 0 then Response.Write "<tr bgcolor='white' align='center'>" Else...
  20. Bigced21

    Need help w/Operation is not allowed when the object is closed

    Here is my code: OpenConnection() Dim rs1 strSQL="Exec sp_GetBoilerTotals_ByCounty" Set rs1=objConn.Execute(strSQL) 'Display current county totals ' Response.Write "<hr width='90%'>" Response.Write "<table width='90%' align='center' rules='all'>" Response.Write "<tr align='center'><td...

Part and Inventory Search

Back
Top