Thanks for the reply. I had suspected that was the case.

That's a very ham-fisted way of doing it.

a = listToArray(reReplace(s, "(.)(?=.)", "\1,", "ALL"));

This assumes the string doesn't contain any commas as data. If there is
likely to be commas in the data, one can use chr(31) as a unit separator
character instead:

a = listToArray(reReplace(s, "(.)(?=.)", "\1#chr(31)#", "ALL"), chr(31));

chr(31) should not appear in text data.

As a general rule of thumb, if one ever finds oneself doing string
processing by looping over the string character-by-character, it's almost
never the best approach to whatever one is doing; so one should consider
revising the approach.

[i]Stack Overflow [/i]
Check the usual suspects: infinite loops or recursions, and rampant object creation.

Just curious why you would want to do this. Not arguing by any means, just wondering what the need might be.

I am doing some playing around with VS08 on my desktop, and I am set up with
dual 22 inch monitors. I have code view on one monitor and preview pane in the
other window. I cant imaging how hard on the eyes it would be to develop on a
tablet.

Of course, I am blind in the right eye, so I need all the help I can get.

The page loads, but my cfgrid is empty. No matter which state I pick, I do not
get results returned to the cfgrid. I am cfoutput'ing the selected value next
to the submit button to be sure that I can select it. Also, as I stated
earlier, the state I pick is passed to the EXEC statement in the SQL query, but
the grid isn't updated. I can see, however that the number of records returned:

qryGetJobsByState (Datasource=ttcmdev_local, Time=32ms, Records=223) in
C:\Inetpub\wwwroot\Demo\cfc\jobsByState.cfc @ 12:42:40.040

EXEC sp_GetJobsByState
@state='Maryland'

Any ideas? Is there something wrong with my code?

If it's not working, what is actually happening?

Bob,

I need some more help.

When I run the cfm file it is supposed to write each record to the attibutes
in xml. But it repeats the emplid of all the records in the first itemdetail's
emplid tag. It repeats for all the attributes of the record. There are 6
records in the database. For the second record, except for the first record in
the database, it displays all the other 5 records.

Do you have any idea? Any help is appreciated.

===============xml output======================


- SupplierName="Aruna">
-
123 124 125 126 127
...

Bob,

You are right. I was not eloborate. It was giving me a matching tag closing
error at to start with, It was not reading the cfm file due to the
that error. Thanks for the corrections. I made all the above suggested changes
and it worked. Thanks a million. Have a great christmas.

I am so close! I figured out how to pass the selected value from the cfselect
to the cfc, but now I cannot seem to make the query run with the passed value.
Here's the cfm:

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
http://www.w3.org/1999/xhtml">