|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 12th, 2004, 02:50 PM
|
|||
|
|||
Creating tables with CF
 hi,thanks for the help in advance. i just had a weird problem. the code below creates a table and inserts some values. however, i just cannot locate the table using SQL Server 2000 Enterprise Manager. where did my table go? <cfquery name="DropTable" datasource="myDB"> DROP TABLE ConLineID </cfquery> <cfquery name="createtable" datasource="myDB"> CREATE TABLE ConLineID (conlineid int, total int); </cfquery> <cfquery name="insertRec" datasource="myDB"> INSERT INTO ConLineID VALUES(1,2323) </cfquery> <cfquery name="getRec" datasource="myDB"> SELECT * FROM ConLineID </cfquery> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> 1 table created! <cfoutput query="getRec">#conlineid# is conline id and #total# is the total....</cfoutput> </body> </html> there is only one CF datasource called MyDB and there is only one database called InvDB.
|
|
#2
August 12th, 2004, 03:09 PM
|
|||
|
|||
|
It's probably in another database...possibly the default database. When you set up your SQL Server DSN, you're connecting to whichever database is the default for that user account.
You might try prefixing the table name with the database that you want to target, ie "myDatabase.myTable".
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
#3
August 12th, 2004, 03:19 PM
|
|||
|
|||
|
Quote:
brain damage, it was actually there where it was supposed to be. sorry
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Creating tables with CF |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
