Search results for query: *

So I am using JSMX and CFMX. I have them working using a simple object or CFFunction output, but I need to transfer an array (really a recordset). I believe I have the server side working properly, but how do I address the resulting array in JS? Sample code: -server side-------------...

So I am using JSMX and CFMX. I have them working using a simple object or CFFuntion output, but I need to transfer an array (really a recordset). I believe I have the server side working properly, but how do I address the resulting array in JS? Sample code: -server side----------- <cfsetting...

I may be mistaken, but currently I can only make arrays work when assigned to discrete numbers (e.g. 1,2,3) and structures only with a defined label (e.g. key1, key2, key3). If this assessment is correct I would like to make an “array” of “structures” which I can’t seem to get right either...

So I can search a file with FINDSTR - but now I need to store it to a variable or parse it in-line to get a single value in the result. For example: FINDSTR "KEYWORD" *.TXT result: KEYWORD = "VALUE" What I need: SET ENV = VALUE -or- 1% = VALUE Anyone know how to do this? Is it possible...

Hey folks! This is my first adventure into the world of JavaScript and I have run into some difficulty. I am wanting to manipulate some objects on in my document in rudamentary fashion, e.g. move them left and right. I found out the hard way that a simple for loop with a time delay is not...

Does ColdFusion maintain a single connection to datasources or does it create a seperate connect for each user? Here is what I am trying to do: I would like to generate a new record in a MySQL DB and retrieve the automatically generated index with a single query to prevent user collision. So...

Sorry, this may be rudamentry, but I am not sure quite how to pull it off. I want to insert a record and read the index value created in a single query. It is not sufficient to insert a record with one query then read the last record with another query as a different user running the same...

So I have accessed my RedHat EL 3 server for about a year using FTP (vsftpd). I have an account set up that can basically browse anyplace on the server. So last night, something froze up and when I re-booted the system, this account can no longer browse deeper than its home directory (using...

Installing ColdFusion MX7 on RH EL 4, everything seems to go ok during the install, except this possible problem: Warning: C++ compatibility pack The installer was unable to determine if the C++ compatibility pack is installed by running the following command: rpm --query compat-libstdc++ If...

I'm sifting through data from a query and I want to be able to address the column name dynamically, but I can't seem to figure out the syntax. e.g. if i have 10 'columns' returned in a query I can refer to each by name: <cfset x[1] = query.column1> <cfset x[2] = query.column2> ... <cfset x[3]...

After development on this web app/ site for a month or more, yesturday, out of the blue, I started to get starnge results, my *.cfm pages were coming up BLANK! Actually, I thought it was some programming error in my code and I was trouble shooting it, when I noticed on a near by computer (as an...

Try as I might, I can't figure this one out. Here is my simple implementation which is not exactly what I want. <CFQUERY NAME="TEST" DATASOURCE="DB"> SELECT * `Data` AS DATA, `Catagory` AS CAT FROM `TABLE` </CFQUERY> <table width="200" > <CFOUTPUT QUERY= "TEST"> <tr> <td>#HTTP#</td>...

Sorry, I posted this earlier in the wrong forum by mistake I have a result in a column that comes as a number e.g. 0.1 - I would like to display this number (during a query) in a percent format e.g. Current Field output: 0.1 1.0 0.34 The preferred output: 10% 100% 34% Thnx for any guidance.

I have a result in a column that comes as a number e.g. 0.1 - I would like to display this number (during a query) in a percent format e.g. Current Field output: 0.1 1.0 0.34 The preferred output: 10% 100% 34% Thnx for any guidance.

Sorry, I know this is going to sound fundamental, but I just can't seem to figure it out from the manual or from an online tutorial. I have a field (x) who's value should be a flag to indicate if the value of another field (y) occurs in a selection of a 3rd field (Z). Such that: X indicates...

Sorry, I know this is going to sound fundamental, but I just can't seem to figure it out from the manual or from an online tutorial. I have a field (x) who's value should be a flag to indicate if the value of another field (y) occurs in a selection of a 3rd field (Z). Such that: X indicates...

I want to declare some variable and use it a few times in a query e.g. x = 30 SELECT count(*) FROM table WHERE field > x

I am trying to filter by a timestamp, without using a 'raw' time stamp in the filter. if I do this: SELECT count(*) FROM table WHERE timestamp > '2006-01-01' I simply get every record, but if i use the raw timestamp: SELECT count(*) FROM table WHERE timestamp > 1136073600 I get the...

I am using MYSQL and I need to run a query on a table where I can serch for records only with a text feild of a specified length (number of characters) e.g. SELECT * FROM table WHERE length('text_field') > x Anyone know the proper syntax?

I need a query that will count the occurance of each unique entry in a specified field. E.G. given the following record set: field1 field2 --- 'x' --- 'y' --- 'x' --- 'w' the result should be similar to: 'x' = 2 'y' = 1 'w' = 1 A critical point (if possible)...