Search results for query: *

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.

Yep figured that out, but not getting the desired results. the following results are returned Array ( [Option1 ] => /var/abc; [Option2 ] => {Option1}/bcd; [Option3 ] => {Option1}/efg Option1 is not replaced by its value i.e. /var/abc whereas the result I want is the one you have mentioned...

hi sleipnir214, Thanks for the solution. I think array_combine is in 5 version. I am using 4.1.x so looking for some way around the array_combine functionality Can you suggest something. Thanks, Dynamo

I need a cross platform config file for a project using both perl and php. I need help in parsing a config file which could be used both by perl and php the file structure for the config file I am thinking could be something like this Option1:/var/abc/ Option2:{Option1}/bcd Option3:{Option1}/efg...

I am setting the cookie as setcookie(User,$UserNameEmail,time()+86400,"/",$argumentstring1,0); where argumentstring1 is the domain on which the cookie is set and $UserNameEmail is the email address. However IE doesn't seem to read the cookie where as Netscape can.

I am setting a cookie, and when I try reading or printing the cookie value ($_COOKIE[cookie_name]), Netscape prints out the cookie value, however IE doesn't seem to read the cookie. Are the cookies handled differently by IE and Netscape. Thanks, Dynamo