Access FP help - Can't wrap my head around this.

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

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

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

Access FP help - Can't wrap my head around this.

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 >> Access FP help - Can't wrap my head around this.

Page: [1]


mesturee Posts: 40 Joined: 9/1/2005 Status: offline	Access FP help - Can't wrap my head around this. - 9/12/2005 16:07:17 I have yet another problem. I have a search page, it contains a form, the form contains three drop down menus and three sets of "range" text boxes. They are all sent as one big request to the same results page. I have a devil of a time figuring out how to write the SQL statement in the DRW to get it to work. I did eventually get the results page to display "no records returned" instead of a data mismatch or too few parameters error. However, I can't get the process to find any records in the database. I know that the criteria is accurate, and yet I constantly get "no records returned". Here is the SQL Statement SELECT * FROM [LSjob] WHERE (TensileLoad >= ::TensileLoadfrom::) AND (TensileLoad <= ::TensileLoadto::) AND (SettingDepth >= ::SettingDepthfrom::) AND (SettingDepth <= ::SettingDepthto::) AND (WaterDepth >= ::WaterDepthfrom::) AND (WaterDepth <= ::WaterDepthto::) AND (CasingSize = '::CasingSizeddb::') AND (CustomerCompany = '::CustomerCompanyddb::')AND (SlipType = '::SlipTypeddb::') ORDER BY JobNumber" TensileLoad from/to = two text boxes SettingDepth from/to = two text boxes WaterDepth from/to = two text boxes CasingSizeddb = drop down box automatically populated by access CustomerCompanyddb = drop down box automatically populated by access SlipTypeddb = drop down box automatically populated by access If any one has any suggestions for "range " searches, I would love to hear them. Thanks for any help Mesturee@sbcglobal.net


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Access FP help - Can't wrap my head around this. - 9/12/2005 17:38:55 If you use the SQL string with actual known data (instead of variables)- does it return records? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to mesturee)


mesturee Posts: 40 Joined: 9/1/2005 Status: offline	RE: Access FP help - Can't wrap my head around this. - 9/12/2005 18:10:48 You, sir.....Are a genius. I just assumed it was the range fields that were giving me problems. After entering in the hard data, it turns out that there was a problem with the one of the other fields. I am still not sure what the problem was, but I changed the = to LIKE and ":: to "%:: on all of the drop down boxes. Now it works perfectly. Thanks.......so much. (in reply to Spooky)