Ask a Question related to Coldfusion Database Access, Design and Development.
-
bcremeans #1
recordset table names problem
I just upgraded to CF 7 and now my table names show up as a file path instead
of just the table name in Dreamweaver when creating new recordsets.
Example: Instead of saying "Employees" it now says
C:\Inetpub\wwwroot\...\databasename.Employees
This makes choosing tables in a recordset a pain now.
Any suggestions?
bcremeans Guest
-
Xtension Dev - Multiple Recordset Field Names
Anthony Brown wrote: Which extension is that? URL? I think that you have to go into the HTML file created by the SBB and add a third... -
Problem inserting a autonumber value from a recordset to another table as text
The problem I'm having is I'm trying to insert a number value (UserID) obtained from the first SQL1 query from a table called User. In the Access... -
How best to grab SQL table names?
I've got a script that goes through SQL files and returns an array of table names. To find table names I use: while ($_ = <FILE>) { if ($_ =~... -
Access table names
That depends on exactly what you are doing. But basically 'work' is a keyword, which is why the problem occurs. If you reference it as it... -
Dataset and table names.....
I have a stored procedure that queries a sql server database and returns the multiple data tables ( 7 to be precise) these tables are the results of... -
Johnny Derk #2
Re: recordset table names problem
Is your db in the wwwroot/db file? also what kind of DB are you using?
Johnny Derk Guest
-
bcremeans #3
Re: recordset table names problem
The DB is an Access database in its own site specific folder. It worked OK
under CF MX 6, but after the upgrade the entire path shows up instead of just
the table name. Everything else works normally otherwise.
bcremeans Guest
-
Johnny Derk #4
Re: recordset table names problem
Try Changing driver to access with unicode
Johnny Derk Guest
-
bcremeans #5
Re: recordset table names problem
I tried Unicode, which fixes the table name problem, but it disables the "Use Default Username" option, which I need due to some linked SQL tables in my Access DB.
bcremeans Guest



Reply With Quote

