Search results for query: *

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.

...Set rs = Server.CreateObject("ADODB.Recordset") rs.ActiveConnection = MM_rs_STRING Select Case strSearchCode Case "11" rs.Source = "SELECT * FROM dbo.vw_Lubrications WHERE Equipment LIKE '%" + Replace(rs__SEARCH, "'", "''") + "%' ORDER BY Equipment ASC" Case "12" rs__SEARCH =...

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

...As Integer If getdates Then Select Case Reportname Case MW3 Set m_Dataconn = getDataConnection() sql = "if exists (select * from sysobjects where id = object_id(N'[vw_Well3_12]') and OBJECTPROPERTY(id, N'IsView') = 1)" & _ " drop view [vw_Well3_12]"...

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?

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

Question: Is there any way below to make 09/10/03, 12/05/03, 04/15/04 start on new lines. I have a MS Access database as the front end, SQL Server as the backend. I have a popup action field created using 'go to Detail Page' that displays as follows: 08/05/03 - A team consisting of Safety...

The body tag is part of the template used for all pages, so if I put the onload on the body tag, it will open on every page. Any suggestions?

I have a message that I want to popup anytime someone opens my home page. Can someone tell me how to do this.

No I don't have On Error Resume Next

I see no difference in the fields that are printing and the fields that aren't printing. If I place 6 of the above fields on the page, they display. If I add a 7th field, it doesn't display. If I remove the 6 fields and place the last two fields on the page, they display the data. any ideas? Is...