Ask a Question related to Coldfusion Database Access, Design and Development.
-
mccldo #1
Db Table with hyphenated column headings
I have a table I can only read from. (Vendor) It has colum headings with things
like MIDDLE-NAME or NAME-ID. Of course, when you do a
<CFOUTPUT>#MIDDLE-NAME#</CFOUTPUT>, it gives a VARIABLE MIDDLE not found.
Question: How do you access a table's column headings that are illegal varibale
names? Currently, we are at CF 6.1.
mccldo Guest
-
different column boarders within a table
It is easy to change the thicknesses of all columns and rows in a table but how to change the thickness of some of the columns and only the vertical... -
add column to table with sql
Does anyone know the SQL syntax to add a column to an existing Access table? -
Datagrid render column headings. ASPX Page Model. Events
I have written a usercontrol which I drop onto aspx pages in my project, this usercontrol performs changes on the content of various aspx controls... -
How do I create a YES/NO column in my table?
I use this code to create a table dynamically... strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));" conn.execute(strSQL) This... -
Repeating column headings
In my ASP programs, I would give style="display:table-header-group" in thead tags. This would make the thead repeat on all pages when I printed a... -
paross1 #2 Re: Db Table with hyphenated column headings
You can alias the column name in your query, then use the alias in you
CFOUTPUT. You will also probably need to enclose the "bad" name within brackets
within the query, such as in the following example.
SELECT [middle-name] AS middle_name,
[name-id] AS name_id
FROM yourtable
blah, blah
Then
<CFOUTPUT> #middle_name# #name_id# </cfoutput>...etc.
Phil
paross1 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
