Search results for query: *

Hi, I have a general question. As a web developer I have primarily worked on PCs my entire life. While in school and on a few job assignments, I've had the opportunity to work on Macs - albeit too briefly. The last time I worked with a Mac was in 2000 and have always had a favorable...

To actually change the query result, but I figured out how to do it: <cfloop query="CustData"> <cfif AcctAccess eq ""> <cfset #AcctAccess[CurrentRow]# = "no"> </cfif> <cfif Current eq ""> <cfset #Current[CurrentRow]# = "no"> </cfif> </cfloop> Hope this helps others and thanks for your...

Hi, I have a query result, CustData. I would like to update 2 fields in the query result, Acct Access, and Current . Since I know the names of these fields, I know that sometimes they are populated and sometimes not. I want to loop through my query result, and say, "If I'm on this particular...

Thanks for the response. How do I incorporate the query as a derived table? Would I already have to have this query performed? The 2nd query is dependent on my Customer ID from the 1st query. I've been playing around with the joins, and I have all of the records I need. I just need to...

I originally posted this in the ColdFusion forum, but since its more of a SQL-related question - thought I'd post here. ------------ I have a query result set that was created with several joins. Here’s the abbreviated version: <cfquery name="CustData" datasource="#request.dsn#"> SELECT...

I have a query result set that was created with several joins. Here’s the abbreviated version: <cfquery name="CustData" datasource="#request.dsn#"> SELECT ….field list values here FROM Customer pc left join area a on pc.area = a.areaid LEFT JOIN layout l ON pc.DefaultInvoiceLayID =...

Hey all, I think I found a answer to my question. I believe HomeSite+ is contained inside DreamWeaver MX. Hope this helps someone. scripter73 Change Your Thinking, Change Your Life.

I have the Macromedia DevNet CD that supposedly has Dreamweaver, Fireworks, Flash, FreeHand, Contribute, and Homesite 5.5 on it. However, when I get ready to install, I don't see an option for Homesite specifically. I've installed it using this CD before, but can't remember steps taken. Is...

Hi r937, That worked. Strange. So it transfers the spaces and returns in the Excel? Thanks for all of your help. scripter73 Change Your Thinking, Change Your Life.

Actually I want the results of one row (all of the fields) in an Excel row. Each field for every query result row shows on a different row in Excel, like: query result1.field1 field2.... fieldn.... query result2.field1 field2.... fieldn.... And so on. Thanks for any advice. scripter73...

Hi, I have a query that returns my resultset in the Excel application. The only problem is every data element is put on another row instead of in another column of the same row for every currentrow. <cfquery name="get_custs" datasource="customers" maxrows=20> select custid, contactid...

Thanks for your suggestions. Right, NorthStarDA, I want them to be dynamic where I don't have to specifically reference each one. r937, it did grab all of the fields. I'm really trying to import these fields into Excel. Your suggestion worked, great. I just have to figure out how to get all...

Hi, I used to know how to do this before I left CF for about a year. Hope this is a simple question. I have a query. <cfquery name="get_cust" datasource="customers" maxrows=20> select custid, contactid, custname_contact, firstname, lastname, type, workphone, address...

Oh, ok. Thanks. Change Your Thinking, Change Your Life.

Hi, I know I should probably pick up a book instead, but I thought I'd ask the community. Has anyone every seen a query statement as the following: <cfquery name="getDaily" datasource="#request.dsn#"> -- #SCRIPT_NAME# #session.username# Select statement..... </cfquery> In my years of...

Hi, Just a quick question. Has anyone taken the ColdFusion TeckCheck exam? If so, could you provide some insight on the types of questions they focus on? Syntax? More logical? I'm currently brushing up with my nose in a book, but just thought I'd take a chance that someone had taken it...

Nevermind....Solved my own problem. It helps I guess if you move the DB to the correct locale. Thanks anyway. Sorry for the inconvenience. Change Your Thinking, Change Your Life.

Hi, I just installed an evaluation version of CFMX and Dreamweaver on my machine. I'm setting up a website to begin going through the tutorial and I have just setup my RDS. My website name is "ows" and I've already created a datasource in the Administrator as "ows". Now when I'm in...

I didn't see your post until now Ecobb. I was thinking something like that may be happening. I'll talk with them again and find out. I'll keep you posted. Thanks for your advice. scripter73 Change Your Thinking, Change Your Life.

Thanks, webmigit, but I already have a "name" attribute set in my <cfapplication> tag as you mentioned. Thanks, too, wbochar, I haven't had to do that before (although I did entered the IsDefined in some of my code). I'll try it again and let you know. Thanks for all of your responses...