can't get WebDNA to display my SQL primary keys via ODBC
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54163
interpreted = N
texte = Hi all, When I try to query a SQL database table with WebDNA, WebDNA does not return the primary key. Given this table: create table department_order ( "department_order_id" int, "cart_id" varchar(50) not null, primary key ("department_order_id") ); This does not show my primary key [department_order_id] but does show the [cart_id]: [SQL dsn=OnlineStore&statement=select * from department_order;] Found [NumFound] items [FoundItems] [department_order_id] [cart_id] [/FoundItems] [/SQL] So, whey can't I list the primary key? Also, this query returns 0 results: select department_order_id from department_order; Upon further review, it looks like WebNDA will not display data types other than character (varchar, char, etc.). Anything that is an int or timestamp, etc., does not get displayed. Does anyone know why this is? Many thanks. -lucas ----------------------------------------------- Lucas Rockwell System Administrator/Programmer The Scholar's Workstation 510.643.6853 lucasr@tsw.berkeley.edu ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- can't get WebDNA to display my SQL primary keys via ODBC ( Lucas Rockwell 2003)
|
Hi all, When I try to query a SQL database table with WebDNA, WebDNA does not return the primary key. Given this table: create table department_order ( "department_order_id" int, "cart_id" varchar(50) not null, primary key ("department_order_id") ); This does not show my primary key [department_order_id] but does show the [cart_id]: [SQL dsn=OnlineStore&statement=select * from department_order;] Found [NumFound] items [founditems] [department_order_id] [cart_id] [/FoundItems] [/SQL] So, whey can't I list the primary key? Also, this query returns 0 results: select department_order_id from department_order; Upon further review, it looks like WebNDA will not display data types other than character (varchar, char, etc.). Anything that is an int or timestamp, etc., does not get displayed. Does anyone know why this is? Many thanks. -lucas ----------------------------------------------- Lucas Rockwell System Administrator/Programmer The Scholar's Workstation 510.643.6853 lucasr@tsw.berkeley.edu ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Lucas Rockwell
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
can WC render sites out? (1997)
WCS Newbie question (1997)
[/application] error? (1997)
(2002)
Using WebMerchant Only? (1998)
[URGENT] Different Results From Math Tag Depending On OS (2006)
emailer w/F2 (1997)
Follow-up to listfiles bug report ... (2003)
[HIDEIF] inside [FOUNDITEM] (1997)
upgrading (1997)
Alpha numeric [CreateDate] (2000)
Converting Quotes in Javascript (2001)
Understanding texta (1997)
multiple search commands (1997)
Re:WebCat for mass emailings (1997)
Running _every_ page through WebCat ? (1997)
Re[2]: Date Time Oddness (1999)
passing search criteria (1997)
carriage returns in data (1997)
Setting up shop (1997)