Recent content by sharonc

Using ASP and SQL Server. Is it possible to search a field using an acronym such as BFP and find Boiler Feed Pump without hardcoding BFP into the table?

I found out what the problem was. I was trying to you a variable in my select statment that didn't exist. Thank you for your help.

Yes, it gives me an error when I try to write out the value of rs.Source.

Hi Sheco, When I put the Response.Write in, it gives me the error: Command text was not set for the command object for the rs.Open() line. Thank you for replying so quickly.

Hi, I am getting this error: Command text was not set for the command object. /projects/Maintenance/search_results.asp, line 42 <b>Can someone tell what is wrong</b> <b>Here is my code:</b> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="../Connections/rs.asp" --> <% Dim...

I need to create a report that looks like the following: It has a header section and then two identical forms follow it: Header section labid: AZ0515 Form1 storet: 00094 sampling date1 9-13-2003 results1 sampling date2 10-13-2003 results2 sampling date3 11-13-2003 results3 Form2 storet...

I am using Visual Basic 6 front end with SQL server 2000 backend. I'm using Crystal Reports 10 for my external reports. When I run my report, there is either minimal data or no data in the report. If I get out of the vb program and double click on the external report, the data is there. Can...

Thank you for your help. I will give this a try. Thanks so much you just saved my fingers from retyping the entire template.

I created a website using a template. Everything has been working good, but now my template is screwed up. My webpages that use the template are fine because I haven't updated the webpages. Is it possible to take one of the pages that are ok and create a new template?

Thank you

I want to print every row in the table. There are 14 rows. How do I print all rows?

Can someone tell me what is wrong with this code? I get #name? on the report instead of the data. 'Load File Header Record 10 to the report strSQL = "Select * from tbl_Rec10;" Set rs = db.OpenRecordset(strSQL) rs.MoveLast rs.MoveFirst For Cntr = 1 To rs.RecordCount...

Thank you, I'll give that a try.

I have a table in my database that I want to read and then write the data of a field from the table to an unbound field on the report. Can this be done?

Thank you, I will give this a try.