CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Syntax error in FROM clause

Print topic Send  topic

Author Message
good4shop

Posts: 6
Posted: 11/03/2006, 10:02 AM

1.I want to add List box in my search page instead of using search box which search words which I pre added in List box SELECT property
its working but one error massage on the top of the page
Source: ListBox s_Title
Error description: Syntax error in FROM clause. (Microsoft JET Database Engine)

2. when I used this script with my other asp pages as INCLUDE its not working
3. its display all record from database table with out search submit i want its display record when some one type or select words in text box or in list box and press search.
waiting for any help
regards
View profile  Send private message
matheus

Posts: 386
Posted: 11/03/2006, 10:58 AM

Do you put the listbox control.

Set Properties > Data.

Data Source Type: Table / View
Data Source: your table
Bound Column: value from table
Text Column: what will display in listbox options.

Or use Data Souce Type: ListOfValues and write.

Then in Grid do you add parameter to get your listbox value.

_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br
View profile  Send private message
good4shop

Posts: 6
Posted: 11/04/2006, 10:46 AM

Dear Matheus

thanks for you reply i am attaching pictures of my CodeCharge software window and my browse so u can better undertand and guide

regards





View profile  Send private message
wkempees


Posts: 1679
Posted: 11/14/2006, 2:29 PM

For your s_title field you have not set the Datasource.
Not the Bound/Text column they (in your case) should be both the text part.

Walter

_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.