Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scripter73
  • Order by date
  1. scripter73

    Mac v. Windows-Based PCs

    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...
  2. scripter73

    How Can I update my Query?

    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...
  3. scripter73

    How Can I update my Query?

    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...
  4. scripter73

    Two SQL statements - Not Sure How to Proceed

    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...
  5. scripter73

    Two SQL statements - Not Sure How to Proceed

    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...
  6. scripter73

    Should I Update My Query?

    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 =...
  7. scripter73

    Installation Question

    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.
  8. scripter73

    Installation Question

    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...
  9. scripter73

    Opening Query Results in Excel

    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.
  10. scripter73

    Opening Query Results in Excel

    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...
  11. scripter73

    Opening Query Results in Excel

    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...
  12. scripter73

    Looping Through Query Results

    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...
  13. scripter73

    Looping Through Query Results

    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...
  14. scripter73

    Basic &lt;CFQUERY&gt; Question

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

    Basic &lt;CFQUERY&gt; Question

    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...
  16. scripter73

    Has anyone taken the CF TeckCheck Exam?

    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...
  17. scripter73

    Dreamweaver Asks for a Datasource Login ID/PWD

    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.
  18. scripter73

    Dreamweaver Asks for a Datasource Login ID/PWD

    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...
  19. scripter73

    Session Variables Not Creating

    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.
  20. scripter73

    Session Variables Not Creating

    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...

Part and Inventory Search

Back
Top