"Loop without do"

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

"Loop without do"

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> "Loop without do"

Page: [1]


pmagas Posts: 367 Joined: 3/26/2002 From: St. Louis MO USA Status: offline	"Loop without do" - 8/11/2004 16:31:30 I'm having problems with FP2003 & the DRW. I've copied the 'old' _fpclass files in but now get this strange error message: quote: Microsoft VBScript compilation error '800a040e' 'loop' without 'do' /analysis/_fpclass/fpdbrgn2.inc, line 5 Loop ^ I've looked through the forum and the problems relating to the DRW in FP2003 and don't see this one. Is it a problem with my site rather than the fpdbrgn2.inc file? _____________________________ Penny humble webmaster of We Sell St. Louis http://www.WeSellStLouis.com http://www.MarkSellsStLouis.net http://www.St-Louis-Mo.info http://www.NealSellsStLouis.com


bobby Posts: 11394 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: "Loop without do" - 8/11/2004 17:14:33 Typically you'll get this where you have a looping function without a "do" paramter (for lack of a better explaination) Correct ASP code should look something like: <% Do while not oRS.eof ' some code oRS.movenext loop %> There might be a conditional if...then statement somewhere above the loop that's messing with it..? _____________________________ If con is the opposite of pro, is Congress the opposite of progress? (in reply to pmagas)


pmagas Posts: 367 Joined: 3/26/2002 From: St. Louis MO USA Status: offline	RE: "Loop without do" - 8/11/2004 17:27:57 I've only looked three times. You know how that goes? I thought I had totally removed the unsuccessful DRW to start fresh, but apparently there's some code left in there. Arrggghhh..... I'm up against a deadline and getting 'stupid.' I still have FP2000 installed - think I should use that for this project and that I'll have more success. (When I'm not under the gun, I'll figure out 2003's DRW) Thanks for your patience! I'd love to start this fresh tomorrow after a nice meal and good night's sleep but it was critical days ago. Time for caffeine and junk food. Thank you!!!! _____________________________ Penny humble webmaster of We Sell St. Louis http://www.WeSellStLouis.com http://www.MarkSellsStLouis.net http://www.St-Louis-Mo.info http://www.NealSellsStLouis.com (in reply to bobby)


bobby Posts: 11394 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: "Loop without do" - 8/11/2004 17:33:14 Try posting the code from that include file... get some more eyes on it _____________________________ If con is the opposite of pro, is Congress the opposite of progress? (in reply to pmagas)


pmagas Posts: 367 Joined: 3/26/2002 From: St. Louis MO USA Status: offline	RE: "Loop without do" - 8/11/2004 19:03:02 Thanks, Bobby! I started some pages 'fresh' using FP 2000 so I don't have to worry about the _fpclass problems. Now I have a logic problem. Here's my code: quote: <% fp_sQry="SELECT * FROM MF2old WHERE ([Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 1-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 2-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 3-# of Bedrooms] >= ::Bedrooms:: OR [Listing Price] >= ::From:: AND [Listing Price] <= ::To:: AND [Address - Zip] LIKE '::Zip::' AND [Area Desc] LIKE '::Area::' AND [Type of Units Desc] = '::Type::' AND [Unit 4-# of Bedrooms] >= ::Bedrooms::) ORDER BY [Net Income] DESC,[Listing Price] DESC" fp_sDefault="From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms=&From=&To=&Zip=&Area=&Type=&Bedrooms=" fp_sNoRecords="No records returned." fp_sDataConn="Database1" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=5 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=31 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %> (I've put it on a Spooky diet.) From the search page, using the defaults, it gives "No Records Found." There are about 440 records and at least 100 should come up with the defaults. I imagine the problem is in my query but I can't find it. Thanks for any insight you might offer. _____________________________ Penny humble webmaster of We Sell St. Louis http://www.WeSellStLouis.com http://www.MarkSellsStLouis.net http://www.St-Louis-Mo.info http://www.NealSellsStLouis.com (in reply to bobby)


BeTheBall Posts: 6359 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: "Loop without do" - 8/11/2004 19:21:17 Back to your original issue, it seems to me I got that error message when I tried to replace only one of the 2003 includes with the FP 2000 versions. Make sure you replace these 3 files with the FP 2000 version: fpdblib.inc fpdbrgn1.inc fpdbrgn2.inc _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to pmagas)


pmagas Posts: 367 Joined: 3/26/2002 From: St. Louis MO USA Status: offline	RE: "Loop without do" - 8/11/2004 19:35:26 Oh, Duane - I had SO many things messed up! I replaced those three files and then I went on to just do stupid stuff (or 'stew-pid' as my daughter would say.) I'd replaced all three of those files but when I 're-did' the DRW, I left old code in the page and it was mightily unhappy. I'll still likely do stupid things until I sleep, but at least in 2000 I'll remember having done those things before. Thanks for your help!!! _____________________________ Penny humble webmaster of We Sell St. Louis http://www.WeSellStLouis.com http://www.MarkSellsStLouis.net http://www.St-Louis-Mo.info http://www.NealSellsStLouis.com (in reply to BeTheBall)