Search results for query: *

Hi, I need to create a database structure (not built in ACL) for groups and user access to certain data. I have done this for just users, but need to get the database structure for a full users, groups, permissions implementation. I know someone out these has a structure already defined. It...

I need some help building a metadata database to associate metadata with content. I have been given a table structure for the main tables shown below but just don't understand it. METADATA TABLE and data ID | KEYWORD 1 | top 2 | dog 3 | car JOIN TABLE STRUCTURE and data ID | ParentID |...

You may find that one of the elements in your array/list, contains a character that it thinks is a delimeter (usually a comma). This would have the effect of making it think it has an extra element in the array. Display all the elements that your putting into the array, and you should discover...

Hi, I have been coding in CF and Javascript for a while now, and although I am quite competent, I don't really know what CF tags are 'allowed' to be used in Javascripts. I am mainly interested in the interaction of the two languages. There have been accasions when I use a CFLOOP or CFIF and...

strantheman has the right idea. Thats what I'd like to be able to do. I just want to be able to inspect the SQL of any query so that I can check it for certain parameters. If the debug can return the SQL to your debug session, surely this must be available somewhere in CF, some 'special'...

Hi, Does any body know how to extract the sql from an SQL query in a CFQUERY tag? I am trying to inpect the SQL and would like to know if anyone has been able to do this. It must be possible, as you can get the SQL when you turn debug on (at the bottom of the screen). Thanks in advance, Puc

Hi I have tried to use the CF_Evaluate before passing it to the span but it evaluates the code and displays it on the page. If I can inhibit this happening then I'd be laughing, but I can't seem to stop the javascript within the CF_datedropdowns tag being output to the screen. I am aware of...

Thanks for your reply. Already used the view source and I can get the exact text I need to be passed to the variable contents as text using DE etc, but then CF does not parse the code it jyst treats it as text. As for the JS, sorry I should have left the eval out, I had a function in there...

Here's the scenario, below is a JavaScript function and some Form HTML. What I need to do is pass the code labelled in red (or *** code I want to pass ***) to the innerHTML of the DIV (box1) so that it produces some dropdown date selector boxes. The problem I am having depending on what I do is...

Does anybody know how to retieve a field list in the right order (i.e. in the same order that the RDS gets it)? I use all sorts of DBs though including MySQL so it has to be a generic solution. It would be amazing if I gould get the datatypes too if anyone knows how to retrieve those.