# symbol in field name

	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

# symbol in field name

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 >> # symbol in field name

Page: [1]


henry81 Posts: 4 Joined: 7/20/2004 Status: offline	# symbol in field name - 9/15/2004 16:17:11 Awwwww!!! Thought I was doing so good with learning this asp stuff.... My database server is Pervasive SQL, the tables I am pulling info from are read-only from our accounting application... THEY!! have a field in a table named USER_ORDER_FIELD_#2 I can display the field data fine, but when I try to put the field in a query......$%^&$%^&!!! I hope there is a way around this... Here is the query statement... fp_sQry="SELECT * FROM I15_ORDERS WHERE ( [USER_ORDER_FIELD_#2] LIKE '%::SEL_TRUCK_TYPE::%' AND [ORDER_TYPE] = 'S' AND [LOCATION_CODE] = '::SEL_LOCATION_CODE::' AND [ORDER_STATUS] LIKE '%::SEL_ORDER_STATUS::%' )" And here is the Error... Database Results Error Description: [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Syntax Error: SELECT * FROM I15_ORDERS WHERE ( << ??? >>[USER_ORDER_FIELD_#2] LIKE '%CUS%' AND [ORDER_TYPE] = 'S' AND [LOCATION_CODE] = '430' AND [ORDER_STATUS] LIKE '%A%' ) Number: -2147217900 (0x80040E14) Source: Microsoft OLE DB Provider for ODBC Drivers What the heck does the << ??? >>> mean ? Is it trying to parse the # symbol and come up with a date or what? Help! henry81....


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: # symbol in field name - 9/16/2004 3:51:46 Yep, dont use special symbols Are you able to create a stored procedure and use alias's? _____________________________ 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 henry81)


henry81 Posts: 4 Joined: 7/20/2004 Status: offline	RE: # symbol in field name - 9/16/2004 9:57:38 Lost me on that one... Is the procedure written in asp or on the pervasive server? I can execute the query in access, why can't we get it to work in frontpage? (in reply to Spooky)


henry81 Posts: 4 Joined: 7/20/2004 Status: offline	RE: # symbol in field name - 9/16/2004 10:54:14 Ok, found where to do stored procedures, how would I setup a stored procedure... Need some direction... It looks like I could copy the table definition using a ddf editor and create an alias to the table and rename the fields... This sounds like fun.....S (in reply to henry81)

Page: [1]

All Forums >> Web Development >> ASP and Database >> # symbol in field name

Page: [1]

Jump to: 1

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