Recent content by Dynamo3209

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

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

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

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

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

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

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

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

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

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

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

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

hi sleipnir214, Thanks for the help. Dynamo.

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

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