Ask a Question related to Coldfusion Database Access, Design and Development.
-
johnmcgary #1
Query exists? Get size / length of field
I'm wondering if there is any way to have SQL return fields and automatically
include the field size. It's such a pain to do manutally, it would just be so
nice just to be able to set the input field's maxlength automatically! If ever
field could just return firstname.length, lastname.length, etc.. that would be
candy.
johnmcgary Guest
-
Field Length Help
I added a new field to my database: <CFQUERY NAME="addColumn" DATASOURCE="#APPLICATION.dsn#" USERNAME="#APPLICATION.dbuser#"... -
Query for MP3 track length
Is there any way that you can store a MP3 in a database and query the DB for the length of a track. I am working on a artist site and I want to... -
copy and paste form RTF document into field in asp form cause it to bypass field length and javascript validation - how to overcome?
I have a web form with several fields. If I copy & paste from a RTF document into a field, the javascript validation and field length are bypassed... -
How do I query whether a toplevel window exists?
have opened 3 additional toplevel windows in my application for input of optional parameters. How can I query if they exist, so I don't recreate... -
Field length
I would like to be able to set a field so you can not enter more than a preset number of characters.... What would the calculation be to make it... -
Frickie #2 Re: Query exists? Get size / length of field
It would be nice and candy indeed, but I do not know of any way to do it.
However, If you have an Oracle DB, you could query the data dictionary and
extract everything you need to know and more about the columns of your tables
(and other DB objects if you wish).
Frickie Guest
-
mxstu #3 Re: Query exists? Get size / length of field
As a side note, maybe you could submit the idea as a feature request. It might be a nice enhancement to the getMetaData() function which can already return the data TypeName for query columns.
mxstu 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
