Avatar of Bob Hoffman
Bob Hoffman
Flag 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

8/22/2022 - Mon
SOLUTION
Scott Fell

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Bob Hoffman

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
Scott Fell

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Bob Hoffman

ASKER
Decided to abandoned FrontPage and use notepad+. Thanks for the advice.
Scott Fell

Good choice
Your help has saved me hundreds of hours of internet surfing.
fblack61
Dave Baldwin

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