|
| |
|
|
A1234
Posts: 104
Joined: 10/7/2004
Status: offline
 |
Display Results Without Search - 12/14/2004 10:00:33
I want my database results to populate my web pages. I defined the zones on each page, but when I open the pages, all I see is "no records returned". How can I get the results to show on the pages without performing a search? 
|
|
|
|
BeTheBall
Posts: 6502
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Display Results Without Search - 12/14/2004 11:01:38
What is the SQL for the page in question?
_____________________________
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.
| |
|
|
|
A1234
Posts: 104
Joined: 10/7/2004
Status: offline
|
RE: Display Results Without Search - 12/14/2004 11:18:19
A little jumbled, but herego
<%
fp_sQry="SELECT * FROM Users WHERE (x_Company LIKE '%x_Company%' OR HomePage LIKE '%HomePage%')"
fp_sDefault="x_Company=&HomePage=&UserID=282"
fp_sNoRecords="No records returned."
fp_sDataConn="prototype"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&UserID=3&x_Firstname=202&x_Lastname=202&UserName=202&x_Email=202&EmailUse=11&Password=202&AddDatetime=135&UpdateDatetime=135&AccessLevel=202&Admin=11&ActiveAccount=11&AccountExpires=135&RemoteAddress=202&LoginCount=3&x_Company=202&x_Address=202&x_City=202&x_State=202&x_Zip=202&x_Country=202&x_Phone=202&x_Cellphone=202&x_Fax=202&x_Website=202&x_Userfound=202&x_Spare=202&x_RefId=202&x_trans_id=202&x_auth_code=3&u_id=3&x_Sex=202&Comments=203&HomePage=202&About=202&Life=202&Testimonials=202&Benefits=202&Hiring=202&Headlines=202&Education=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
Thanks!
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Display Results Without Search - 12/14/2004 11:47:10
quote:
fp_sDefault="x_Company=&HomePage=&UserID=282"
Try making this line this:
fp_sDefault="x_Company=&HomePage=&UserID="
See, you had a default UserID set. If it's a full DWR (not dieted), you'll have to go back thru the steps and remove the Defaults in the Criteria section. (That is IIRC!)
Hope it helps.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
A1234
Posts: 104
Joined: 10/7/2004
Status: offline
|
RE: Display Results Without Search - 12/14/2004 11:59:29
Thanks very much, but that still didn't do the trick. I finally got the results to show on the page (without search), but it is showing results for all users. The reason I had UserID-282 in the sql above is because I just wanted that particular users results shown (this is his personal web page within my site). My sql now looks like this
<%
fp_sQry="SELECT * FROM Users"
fp_sDefault="x_Company=&HomePage="
fp_sNoRecords="No records returned."
fp_sDataConn="prototype"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&UserID=3&x_Firstname=202&x_Lastname=202&UserName=202&x_Email=202&EmailUse=11&Password=202&AddDatetime=135&UpdateDatetime=135&AccessLevel=202&Admin=11&ActiveAccount=11&AccountExpires=135&RemoteAddress=202&LoginCount=3&x_Company=202&x_Address=202&x_City=202&x_State=202&x_Zip=202&x_Country=202&x_Phone=202&x_Cellphone=202&x_Fax=202&x_Website=202&x_Userfound=202&x_Spare=202&x_RefId=202&x_trans_id=202&x_auth_code=3&u_id=3&x_Sex=202&Comments=203&HomePage=202&About=202&Life=202&Testimonials=202&Benefits=202&Hiring=202&Headlines=202&Education=202&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
How do I get it to just show results for UserID=282? Thx again
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Display Results Without Search - 12/14/2004 12:46:05
quote:
How do I get it to just show results for UserID=282?
Are you sure there are records for user 282? 'Cause, to me, the code you posted should have done it...
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 