Search results for query: *

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

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

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

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

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

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?

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

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

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

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

Chopstick your code returned a -1

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

although it runs in query analyzer????

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

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

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

Nope, still getting the same error

No

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

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