Database-CF admin

[Counselnitin]

hey,
I just realised I dont have access to the cold fusion administrative page and
im trying to figure out the tables that exist on the database. I understand
this can be done through the cfquery and cfgrid tags but i was hoping somebody
could give me insight into what i might need to do.
thanks

[Nebu24]

Hi,

I had the same problem once when i did an update. First of all you need to
make sure your webserver is up and running. If so two things can be wrong:
1) Your CFIDE files are not on your computer
2) Your hyperlink is pointing to a false directory (not likely)

To find out if your cfide files are on your computer goto your default web
directory if you are using IIS i believe this is C:\Inetpub\wwwroot (\htdocs
not sure about the last), for apache C:\Program Files\Apache
Group\Apache2\htdocs. The map should contain a map named CFIDE. If so try the
following url:
[url]http://127.0.0.1/[/url] (your default webserver path)
[url]http://127.0.0.1/cfide/administrator/[/url] (happy administrating)

This should work now.

If the map CFIDE does not exists you need the copy them from another computer
on your comp in the map i just mentioned.

Well hope i helped you on your way.

Greetings Nebu

[Counselnitin]

Hi,
I think my description of the problem was inadequate. The CF server is running
on the school server. I tried to get access to the administrative page but was
told they dont really want people accessing the database. I was told that the
only way I can determine the tables that exist in my DB was through the
CFquery and CFgrid tag. hope this helps
nitin

[mxstu]

Counselnitin,

You can use cfquery to get the list of tables in your database. The exact
syntax depends on what database you're using. Once you have the list of tables
in a cfquery object, you can use cfgrid to display the information, but it is
not required. If you just want to display the list, you can use something as
simple as cfdump or cfoutput.



<!--- assumes correct datasource/database permissions --->
<!--- sql server database --->
<cfquery name="getTableNames" datasource="yourSQLServerDSN">
SELECT Table_Name
FROM Information_Schema.Tables
WHERE Table_Catalog = 'yourDatabaseName'
</cfquery>
<cfdump var="#getTableNames#">
<!--- mySQL database --->
<cfquery name="getTableNames" datasource="yourMySQLDSN">
SHOW TABLES FROM yourDatabaseName;
</cfquery>
<cfdump var="#getTableNames#">

[Counselnitin]

Connection to LDAP Server failed
The error occurred in
/afs/.glue.umd.edu/department/oit/eis/webhosting/counseling/htdocs/cfcommon/scri
pts/_Auth_UMCPLDAP_.cfm: line 61
Called from
/afs/.glue.umd.edu/department/oit/eis/webhosting/counseling/htdocs/cfcommon/scri
pts/_CommonLogin_UMCPLDAP_.cfm: line 67
Called from
/afs/.glue.umd.edu/department/oit/eis/webhosting/counseling/htdocs/DSS/OnlineFor
ms/TestRequest/Application.cfm: line 57

59 : password="#rt.ldapPW#"
60 : name="ldapRetrieve"
61 :
attributes="employeeNumber,cn,givenName,sn,umIniti als,umMiddleInitial,umDisplayN
ame,umDisplayNameLF,mail,telephoneNumber,postalAdd ress"
62 : filter="(uid=#rt.ldapID#)"
63 : start="dc=people,dc=ldap, dc=umd, dc=edu"


I get this error message when i attached the code. Im not sure about what this
really means
nitin

[Counselnitin]

i think it is an oracle database
nitin

[mxstu]

Sorry I can't help you with the LDAP error message. It looks like something
specific to your application.

I'm not using oracle but this link provides some information on retrieving
metadata in Oracle databases
[url]http://www.oreillynet.com/pub/a/network/2002/10/28/data_dictionary.html[/url]

[Counselnitin]

Hi,
Ive reached the point where Im now trying to query the datasource to view the
tables. This is the code ive attached. But i cant seem to be able to display
the structure of the table on the screen. Is there a tag I need to attach to
get it to work
code :
<cfquery name="SG_QUESTION_DATA" datasource="#application.ds#">
select Column_Name, Data_Length, Data_Type
from USER_TAB_COLUMNS
where Table_Name = 'SG_QUESTION_DATA'
</cfquery>
thanks
nitin

[mxstu]

If the display is just for debugging purposes, the easiest method is to use
cfdump:

<cfdump var="#SG_QUESTION_DATA#">

Otherwise, you can use cfoutput with the "query" attribute:


<cfoutput query="yourQuery">
#someColumn1# #someColumn2# ... etc... <br>
</cfoutput>

[Counselnitin]

Hi,
Yes, im now able to view a few of the columns. Im not sure but what does
"USER_TAB_COLUMNS" imply ? I know for a fact that there should be a column name
with first name and last name but they dont show on my view. Is there something
im missing ?
nitin

[Counselnitin]

okay, so i finally figured out what USER_TAB_COLUMNS does. Its just that now im
a little confused on why there might be a few fields that are actually not
displayed. the variables first name and last name do not show up on the
listing. any ideas why
nitin

[paross1]

FYI, if you want the structure of the table, you could use the DESCribe command
via SQL Plus, but it looks like you do not have access to the database for
this. The query below will give you an approximation of what you would see
using DESC.

SELECT column_name,
decode(nullable,'N','NOT NULL','Y',NULL) nullable,
replace(data_type||'('||NVL(DATA_PRECISION,CHAR_CO L_DECL_LENGTH)||
')','()','') type
FROM user_tab_columns
WHERE table_name= 'SG_QUESTION_DATA'

Phil

[Counselnitin]

Is there some way I can alter some of the tables that have been created. It is an oracle database.
thanks
nitin

[paross1]

I don't know why you wouldn't be able to perform ALTER table DDL commands, provided that the account used by ColdFusion to access the Oracle database has the appropriate privileges.

Phil