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,
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.