Avatar of Bob Hoffman
Bob HoffmanFlag for United States of America

asked on 

frontpage webbot change blows away existing grid format

I'm using frontpage 2003 to make a small change to an existing classic asp site. I need to make a change to the SQL select statement used via webbot to create a grid. The problem is I can't figure out how to make the change without going into the Database Results Wizards. The wizard want to rebuild the entire grid which will blow out all my formatting.
ASP

Avatar of undefined
Last Comment
Dave Baldwin
SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Bob Hoffman
Bob Hoffman
Flag of United States of America image

ASKER

I have this:

<%
fp_sQry="SELECT * FROM thread_gages2 WHERE ( ('::search1::' <> '' AND (serial1 LIKE '::search1::%' OR barcodenum1 = '::search1::')) OR (size1 LIKE '::search2::%' AND color1 LIKE '::search3::%') ) ORDER BY updatedate1 DESC"
fp_sDefault="search1=&:search1=search1=&search1=search1=&search1=&search2=search2=&search3=&search3="
fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%""> </td></tr>"
fp_sDataConn="cgs_admin"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=10
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&idnum1=72&serial1=200&barcodenum1=200&certnum1=200&type1=200&size1=200&fraction1=202&color1=200&atspec1=200&department1=200&location1=200&dateissued1=135&datereturned1=135&employee1=200&shift1=200&loanedto1=200&caldate1=135&calduedate1=135&outforcal1=200&outforcal2=135&missing1=200&adjusted1=200&repaired1=200&replaced1=200&notes1=200&updatedate1=135&po1=3&"
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

when I change this and save the file I get this error:

the contents of a FrontPage component have been modified. These contents will be overwritten when you save this page.

I also have this:

<!--webbot bot="DatabaseRegionStart" s-columnnames="idnum1,serial1,barcodenum1,certnum1,type1,size1,fraction1,color1,atspec1,department1,location1,dateissued1,datereturned1,employee1,shift1,loanedto1,caldate1,calduedate1,outforcal1,outforcal2,missing1,adjusted1,repaired1,replaced1,notes1,updatedate1,po1" s-columntypes="72,200,200,200,200,200,202,200,200,200,200,135,135,200,200,200,135,135,200,135,200,200,200,200,200,135,3" s-dataconnection="cgs_admin" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="TRUE" s-recordsource="thread_gages2" s-displaycolumns="serial1,certnum1,size1,type1,fraction1,color1,department1,location1,caldate1,calduedate1,outforcal2" s-criteria="[serial1] BEG {search1} | [barcodenum1] EQ {search1} | [size1] BEG {search2} | [color1] BEG {search3} |" s-order="[updatedate1] -" s-sql="SELECT * FROM thread_gages2 WHERE ( ('::search1::' <> '' AND (serial1 LIKE '::search1::%' OR barcodenum1 = '::search1::')) OR (size1 LIKE '::search2::%' AND color1 LIKE '::search3::%') ) ORDER BY updatedate1 DESC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="search1=&amp:search1=search1=&amp;search1=search1=&amp;search1=&amp;search2=search2=&amp;search3=&amp;search3=" s-norecordsfound=" " i-maxrecords="0" i-groupsize="10" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FF0000&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network. The custom query contains errors.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan -->


I've had some success changing both of these in notepad but it seem crazy that I need to do it this way.  Thanks
ASKER CERTIFIED SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Bob Hoffman
Bob Hoffman
Flag of United States of America image

ASKER

Decided to abandoned FrontPage and use notepad+. Thanks for the advice.
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Good choice
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Yes, I agree.  I've taken over sites done in FrontPage and had to redo them completely.  Matter of fact, I was just working on one that was done in FrontPage about 7 years ago.  As changes are requested, I try to bring the pages up to where the 'state of the art' was in 1999...
ASP
ASP

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

82K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo