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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Dynamo3209

  1. Dynamo3209

    Deleting multiple rows from a table

    Hi, I am trying to delete multiple rows from one table and using this following query Delete from table WHERE name IN ('a@hotmail.com',' b@hotmail.com',' j@yahoo.com',' j@gmail.com') This query only deletes the first email address in the array that is only a@hotmail.com is deleted. An array...
  2. Dynamo3209

    Displaying query results horizontally

    Hi, I am using the following code to get the results from two queries and want to display the results in a horizontal format like ClientName Loc TotOrd Product1 Product2 Product3 Client1 Loc1 6 2 3 1 client1 Loc2 5 1 2 2 client2 Loc1...
  3. Dynamo3209

    Problem displaying data in a table format

    Hi Ecobb, Can you give me some ideas how to go about for accomplishing the desired results as I have mentioned in my last post. Thanks, Dynamo
  4. Dynamo3209

    Problem displaying data in a table format

    Hi Ecobb, I can loop through each element as follows <cfset length1 = listlen(ordertotals)> <cfloop index="element" from="1" to="#length1#"> <cfset currentorder = listGetAt(ordertotals, element)> and get the value of each element But I am stuck at how to display the results in the table...
  5. Dynamo3209

    Problem displaying data in a table format

    Hi Ecobb, I need to generate a report for total orders grouped by client and location, one client may have several locations, so the report needs to be grouped by client and location and one client from one location may order several products so I have to display the total orders from a client...
  6. Dynamo3209

    Problem displaying data in a table format

    Hi, I am using the following code <cfquery name ="Company_Totals" datasource="ABC"> SELECT Clients.ClientID, Clients.ClientName, Customers.ClientID, Customers.CustID, Clients.Location, count(Clients.ClientID) As TotalOrders, Orders.Status...
  7. Dynamo3209

    Query Grouping Problem

    Hi, I am pulling out some records from the database like ClientName, OrderID, ClientLocation, Productsordered. I have to generate a report in coldfusion for total orders received by client name and location and give a breakup of products ordered. Something like this Client1 - Location1...
  8. Dynamo3209

    Serverfile names of uploaded files

    Hi bombboy, Thanks it worked though instead of <cfset aFiles[i] = destination&cffile.serverFile> used <cfset aFiles[i] = cffile.serverFile> as was getting undefined destination error and specified the directory while attaching the files in cfmail tag. Thanks Dynamo
  9. Dynamo3209

    Serverfile names of uploaded files

    Hi, I have a routine to upload upto three files to the server and then email these files the code I am using for uploading the files is <cfset filename = ""> <cfloop index="i" from="1" to="3" step="1"> <cfif Len(Trim(form["file" & i]))> <cffile action="UPLOAD"...
  10. Dynamo3209

    How to parse config files in php

    Hi, Found out what the problem is with fgets you have to define the lenght which will be returned/read from the file pointed to by handle like fgets($file, 1000) Thanks, Dynamo
  11. Dynamo3209

    How to parse config files in php

    Hi, Appreciate your quick response. But I am getting these error msgs Warning: Wrong parameter count for fgets() in /usr/local/abc/web/users.abc.com/parsing.php on line 18 Warning: Wrong parameter count for fgets() in /usr/local/abc/web/users.abc.com/parsing.php on line 18 Array ( ) Line...
  12. Dynamo3209

    How to parse config files in php

    Hi sleipnir214, As in the parsing routine you had mentioned that the setting referenced must have already been defined. However now I have to make some more changes in the parsing routine. As we have two server, one development and one production so for ease of portability I divided the file to...
  13. Dynamo3209

    How to parse config files in php

    hi sleipnir214, Thanks for the help. Dynamo.
  14. Dynamo3209

    How to parse config files in php

    hi sleipnir214, Run into one more problem how do we parse this case hostDomain: abc.com BASEPATHSECURE : http://users.{hostDomain}/ Thanks, Mohit
  15. Dynamo3209

    How to parse config files in php

    Thanks a lot sleipnir214, it worked. I must be doing something wrong earlier. Again thanks a lot for helping me out. Dynamo.
See more

Part and Inventory Search

Back
Top