Decryption problem.
Hi,
This has really been bugging me and I have decided to give up and ask
for help.
We have an application written in .NET that is used for user management.
After various problems (mostly from a lack of understanding in .NET) I
decided to rewrite the front end in CF. The front end talks to a web
service that is written in .NET
The problem I am having is:
The web service returns all expected fields, however one of the fields
is encrypted and I need to decrypt it. I have the key that was used to
encrypt it but can't figure out how to do it in CF. The closest I have
gotten to getting it working is the following error:
There has been an error while trying to encrypt or decrypt your input
string: The input and output encodings are not same
I have the .NET code used to decrypt the field, but having trouble
working out what exactly it is doing.
Private Shared Function Decrypt(ByVal strText As String, ByVal
sDecrKey _
As String) As String
If strText = Or strText = nbsp; Then Exit Function
Dim byKey() As Byte = {}
Dim IV() As Byte = {H12, H34, H56, H78, H90, HAB, HCD,
HEF}
Dim inputByteArray(strText.Length) As Byte
Try
byKey = System.Text.Encoding.UTF8.GetBytes(Left(sDecrKey,
8))
Dim des As New DESCryptoServiceProvider
inputByteArray = Convert.FromBase64String(strText)
Dim ms As New MemoryStream
Dim cs As New CryptoStream(ms, des.CreateDecryptor(byKey,
IV), CryptoStreamMode.Write)
cs.Write(inputByteArray, 0, inputByteArray.Length)
cs.FlushFinalBlock()
Dim encoding As System.Text.Encoding =
System.Text.Encoding.UTF8
Return encoding.GetString(ms.ToArray())
Catch ex As Exception
'Return ex.Message
Return
End Try
End Function
Is anyone able to point me in the right direction?
Regards,
Mark Picker
**
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216457
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Decryption problem.
looks like public private key encryption using a des algorithm.
I think cfmx7 supports des, but not sure.
You could use java, either compiled or via cfscript.
Heres the first thing google gave me:
http://www.orlingrabbe.com/des_java.htm
-Original Message-
From: Picker, Mark [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 08:02
To: CF-Talk
Subject: Decryption problem.
Hi,
This has really been bugging me and I have decided to give up and ask
for help.
We have an application written in .NET that is used for user management.
After various problems (mostly from a lack of understanding in .NET) I
decided to rewrite the front end in CF. The front end talks to a web
service that is written in .NET
The problem I am having is:
The web service returns all expected fields, however one of the fields
is encrypted and I need to decrypt it. I have the key that was used to
encrypt it but can't figure out how to do it in CF. The closest I have
gotten to getting it working is the following error:
There has been an error while trying to encrypt or decrypt your input
string: The input and output encodings are not same
I have the .NET code used to decrypt the field, but having trouble
working out what exactly it is doing.
Private Shared Function Decrypt(ByVal strText As String, ByVal
sDecrKey _
As String) As String
If strText = Or strText = nbsp; Then Exit Function
Dim byKey() As Byte = {}
Dim IV() As Byte = {H12, H34, H56, H78, H90, HAB, HCD,
HEF}
Dim inputByteArray(strText.Length) As Byte
Try
byKey = System.Text.Encoding.UTF8.GetBytes(Left(sDecrKey,
8))
Dim des As New DESCryptoServiceProvider
inputByteArray = Convert.FromBase64String(strText)
Dim ms As New MemoryStream
Dim cs As New CryptoStream(ms, des.CreateDecryptor(byKey,
IV), CryptoStreamMode.Write)
cs.Write(inputByteArray, 0, inputByteArray.Length)
cs.FlushFinalBlock()
Dim encoding As System.Text.Encoding =
System.Text.Encoding.UTF8
Return encoding.GetString(ms.ToArray())
Catch ex As Exception
'Return ex.Message
Return
End Try
End Function
Is anyone able to point me in the right direction?
Regards,
Mark Picker
**
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216458
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Replace or REReplace function question.
Thanks all. I have decided to go with the following syntax for my fieldnames fieldname1, fieldname2, etc just to avoid any problems with the hashes. As there will be limited few fields to deal with I think the less elegant but simpler 'replace' function should do the job, unless you know of any example code for doing it better? -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 August 2005 18:15 To: CF-Talk Subject: Re: Replace or REReplace function question. First, I'd recommend not using CF markup for the fields. Or at least don't require the CFOUTPUT tags, just the hashes. If you have a small number of fields, loop over them and just do a replace(string, ##detail.firstname##, detail.firstname, all) for each one. Not real elegant, but it is simple. A more robust solution would be to parse the text for hashes, and then check the contents of each pair (making sure to gracefully deal with floating hashes that aren't delimiters) and substituting the right content in it's place. This is a lot more complex, because you'll be doing a seek/cut/insert loop, rather than just replacing content, but it allows for a lot more flexibility. cheers, barneyb On 8/25/05, Andy Mcshane [EMAIL PROTECTED] wrote: Hi all, I am trying to come up with a way to do the following; User creates/edits a basic letter/mailshot document on line using FCKeditor. Within this document the user can add some pre-defined CF output fields i.e. cfoutput#details.firstname#/cfoutput. This is with the idea of trying to do a simple mailshot by extracting the names and addresses required from the database, selecting the letter/mailshot text from the database, looping thorugh the recordset inside of a cfdocument tag and producing a PDF of all the letters. The point at which I am stuck is actually replacing the output tags inserted into the original text with the required data from the database before allowing cfdocument to process it. Does anyone have any suggestions/ideas on the best way to replace my tags with the required text? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216459 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Decryption problem.
There has been an error while trying to encrypt or decrypt your input string: The input and output encodings are not same I have the .NET code used to decrypt the field, but having trouble working out what exactly it is doing. The Decrypt function can decrypt DES encrypted data. I don't think it allows the use of an init vector though, so you'll have to use directly the java objects... -- mack / ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IIS 6 VS Apache
| You can expect me to go through hundreds of folders and set | the acl on | every .svn subfolder. | No, that would probably be an impractical approach. However, you could | easily do exactly that with a batch file and cacls.exe. The problem | with that approach would be that you may add new .svn folders in the | future, and you'd have to rerun the batch file. Dave and Russ -- you could do it in a more fail/safe manner as well, make sure that acl's are not inherited, and doing the svn operations through accounts in a restricted group. I think so at least -- wouldn't the svn folders be created disallowing access to the IIS user? Alternatively, do the checkout and make sure that the IIS user does not have access to any folders, then open up the directories manually. /Hugo ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216462 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tinymce file manager
http://www.webworksllc.com/cffm/ integrates with TinyMCE. On 8/26/05, Stan Winchester [EMAIL PROTECTED] wrote: Has anyone made a image/file manager for Tinymce? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FCKeditor Fusebox4.1
Thanks Barney, that's what I was thinking along those lines so your comments help enforce my argument with my 'he who cannot be wrong' manager! -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 August 2005 18:30 To: CF-Talk Subject: Re: FCKeditor Fusebox4.1 With an admin application, you necessarily have to trust the content your users are adding. How far you trust them depends on the app, but in general, you have to assume they know what they're doing, and if they enter malicious code, that's what they wanted. I.e. it's policy enforcement, not technical enforcement. cheers, barneyb On 8/25/05, Andy McShane [EMAIL PROTECTED] wrote: I will do. Another quick point, anybody who has had any experience with FCKeditor and saving the entered content into a SQL server database, are there any critical things to look out for i.e. any string replacement that needs to be done in order to save the content? Ways to prevent malicious code being entered? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL Count Question...
I am trying to get a total count of all our records. The query itself is a join
( as you can see below )... however when I make a change between the following
I get a different result set... I want to be able to return the correct number
of records but do it the correct way and not return a list of ids ( then do a
#queryname.recordCount# ), rather I just want a proper count returned as I am
trying to do in query2 below.
The two queries are identical except for the top portion, directly below.
query 1 snippet // this returns a listing 3500 records
SELECT DISTINCT 'id' = opportunity.id
/query 1 snippet
query 2 snippet // this returns a count of 135,000+ records
SELECT DISTINCT count(opportunity.id) as total_records
/query 2 snippet
/* also tried
count(*),
count(id = opportunity.id),
count('id' = opportunity.id)
*/
FULL SQL CODE...
query 1
SELECT DISTINCT
'id' = opportunity.id
FROMopportunity,
advertiser,
location
WHERE opportunity.deleted
= 'N'
AND
opportunity.authorised
= 'Y'
AND
opportunity.active
= 'Y'
AND
opportunity.activate
= getdate()
AND
opportunity.deactivate
= getdate()
AND
opportunity.advertiser_id
= advertiser.id
AND
advertiser.deleted
= 'N'
AND
advertiser.suspended
= 'N'
AND
(
(0 = 0 OR levels LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0 OR levels LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')
) AND
(0 = 0 OR sectors LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')AND
(0 = 0 OR work_types LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')
AND
(
0 = 0 OR
(0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%'
AND
0 LIKE'%' + ',' + CONVERT(VARCHAR,0)
+ ',' + '%')
)
/query 1
query 2
SELECT DISTINCT
count(opportunity.id) as total_records
FROMopportunity,
advertiser,
location
WHERE opportunity.deleted
= 'N'
AND
opportunity.authorised
= 'Y'
AND
opportunity.active
= 'Y'
AND
opportunity.activate
= getdate()
AND
opportunity.deactivate
= getdate()
AND
opportunity.advertiser_id
=
SQL Server Instances and CF 7
I have a database that multiple sites are going to use and contains a substantial amount of data. Is there any way in SQL server you can make an instance of the database and allow different sites to hit the different instances keeping the sqlserver.exe from taking up too much cpu and memory? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216465 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Event Gatways: session scope?
Yes, both session scope and client variables are available to you in Event Gateway apps, including the IM gateways as well. Check out Chapter 44-48 in the Developing Apps book for an excellent tour and walkthrough of building Event Gateway apps. Good stuff and well worth the read. Just enable session variables and/or client variables in your app as you would for a web app and things should work fine. Damon Hey guys, Im just getting started with event gateways and trying to figure out what I can and cant do. Is the session scope available in gateways? specifically the IM gateway? Regardless of the answer to the above question, is there a way short of datastore access that you can store values and retrieve them later based on who the gateway is talking with? I have tried a couple of different ways, which I can explain if needed, but no dice so far. I could also be looking over something in my code as well. Thanks for any response. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 Want gmail? Get it here while its hot. www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216466 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: CSS: image overflow in IE vs Firefox
Dave,
Can you put up a sample page so I can see the situation? I think you are
running into an IE bug, but I am not sure yet.
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 10:59 PM
To: CF-Talk
Subject: re: OT: CSS: image overflow in IE vs Firefox
~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time.
From: Damien McKenna [EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 6:22 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: OT: CSS: image overflow in IE vs Firefox
I'm working on a site where I'm attempting to make some images float outside
their parent div, as you'd often see in magazines where you've e.g. got a
column of text with an inserted image that pushes out wider than the text.
The way the page is set up is that there's text in the middle with one image
on floating on the left and one floating on the right, both of which are
supposed to push outside of the text column.
Here's one image that's supposed to float left:
div.insertLeft {
position: relative;
display: inline;
float: left;
width: 160px;
left: -25px;
}
This one is supposed to float right:
div.insertRight {
position: relative;
display: inline;
float: right;
width: 120px;
}
It looks simply beautiful in Firefox and was the reason I did the I love
CSS post the other day. However, today I viewed it in IE and the
positioning is all off - the left image is positioned correctly but the text
flows 25px away from it instead of the 5px it should, and the right image
just floats right against the border as if I didn't have the width
attribute in the stylesheet at all.
Aside: /me thinks he's hit upon box model differences.
Any suggestions on how to do what I want to do? I'll try css-discuss
tomorrow if nobody has any ideas. Thanks.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu
Company - http://www.thelimucompany.com/ - 407-804-1014 #include
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216467
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server Instances and CF 7
Not sure I get this? SQL Server will use as much memory / CPU as it needs to regardless of instances. Remember each database is essentially an instance but the Server itself is global and that memory cannot be managed. If you want separate instances you will want separate boxes and separate licenses for SQL. -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 12:20 To: CF-Talk Subject: SQL Server Instances and CF 7 I have a database that multiple sites are going to use and contains a substantial amount of data. Is there any way in SQL server you can make an instance of the database and allow different sites to hit the different instances keeping the sqlserver.exe from taking up too much cpu and memory? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IIS 6 VS Apache
Russ Any reason why you cannot do svn export to deploy the application without the subversion system files? Kola -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 25 August 2005 21:23 To: CF-Talk Subject: RE: IIS 6 VS Apache Well acl's won't work well here, because .svn folders are created in every folder of your application by the subversion client. You can expect me to go through hundreds of folders and set the acl on every .svn subfolder. The reason I suspect it's easier with Apache is because apache has a lot of different options for the config file, and I bet one of those directives will do just what I want... disallow access to .svn folders. IIS just has the GUI, which isn't very rich, and I don't remember any options anywhere for disallowing access to specifically named folders. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 4:09 PM To: CF-Talk Subject: RE: IIS 6 VS Apache What about doing things such as blocking certain directories... like for example I want to block the .svn directory from being accessible from the web. I haven't figured out how to do it in either Apache or IIS, but I have a feeling it's much easier in apache... That strikes me as a silly thing to say. If you don't know how to do it with either one, what is the basis for your feeling? If you have a specific directory that you want to manage with regard to IIS, you set ACLs on it appropriately. Just like you'd set ACLs on files in a SMB share. So, for people who have that experience - practically every Windows server administrator in the world - I suspect IIS is easier. If you don't know how to set ACLs, I imagine it's a toss-up. But honestly, you're putting way too much thought into this, I suspect. Either IIS 6 or Apache will do what you need them to do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
I don't think you can use DISTINCT with an aggregate function like count().
Also, you didn't indicate anywhere in this e-mail which database server you're
using.
Are you doing the query just to get the count, or is it for some other purpose
as well. There's nothing wrong with using #queryname.recordcount#. You could
do the count() without the DISTINCT, but that may give you more than you are
looking for.
Maybe you could tell us the goal you're trying to accomplish and there might be
another way to approach it. Be sure to include your SQL database type and
version. Also, providing your error message is very helpful.
Dave
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 6:47 AM
To: CF-Talk
Subject: SQL Count Question...
I am trying to get a total count of all our records. The query itself is a join
( as you can see below )... however when I make a change between the following
I get a different result set... I want to be able to return the correct number
of records but do it the correct way and not return a list of ids ( then do a
#queryname.recordCount# ), rather I just want a proper count returned as I am
trying to do in query2 below.
The two queries are identical except for the top portion, directly below.
query 1 snippet // this returns a listing 3500 records
SELECT DISTINCT 'id' = opportunity.id
/query 1 snippet
query 2 snippet // this returns a count of 135,000+ records
SELECT DISTINCT count(opportunity.id) as total_records
/query 2 snippet
/* also tried
count(*),
count(id = opportunity.id),
count('id' = opportunity.id)
*/
**
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to
the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to anyone
else.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216470
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, You can use isnull() in SQL Server and nvl() in Oracle. I don't know which DB you're using. Dave -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 4:53 PM To: CF-Talk Subject: Quick Query Question...[hopefully] If have a query that returns a 24 hour breakdown of orders by the hour on a monthly basis. (see below). As you can see, Hour 5 6 are missing because there are no values to return. What would be the easiest way to add Hour 5 and Hour 6 to the query's recordset with a corresponding value of zero for each hour? The trick is, from month to month, the hours that have no values might change. Any idee-ers? Thanks, Che. HOURTOTALORDERSPERHOUR 0 5 1 5 2 4 3 2 4 2 7 3 8 2 9 10 10 7 11 7 12 3 13 5 14 11 15 10 16 6 17 13 18 7 19 13 20 9 21 16 22 11 23 14 ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216471 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Dave, below is my query...how would I make the query work with isnull() on SQL Server 2000? Thanks, Che. SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC Che, You can use isnull() in SQL Server and nvl() in Oracle. I don't know which DB you're using. Dave -Original Message- If have a query that returns a 24 hour breakdown of orders by the hour on a monthly basis. (see below). As you can see, Hour 5 6 are missing because there are no values to return. What would be the easiest way to add Hour 5 and Hour 6 to the query's recordset with a corresponding value of zero for each hour? The trick is, from month to month, the hours that have no values might change. Any idee-ers? Thanks, Che. HOURTOTALORDERSPERHOUR 0 5 1 5 2 4 3 2 4 2 7 3 8 2 9 10 10 7 11 7 12 3 13 5 14 11 15 10 16 6 17 13 18 7 19 13 20 9 21 16 22 11 23 14 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, If you are going to use isNull in this case you will need an ugly case statement inside your query. Even then, I'm not sure it's possible. You can wrap it in a stored proc and do some looping to return a temp table. If all you are doing is displaying this data in CF I would just loop from 0 to 23 and tease out the values rather than try to insert placeholders into the data. -Mark -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 7:39 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Dave, below is my query...how would I make the query work with isnull() on SQL Server 2000? Thanks, Che. SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC Che, You can use isnull() in SQL Server and nvl() in Oracle. I don't know which DB you're using. Dave -Original Message- If have a query that returns a 24 hour breakdown of orders by the hour on a monthly basis. (see below). As you can see, Hour 5 6 are missing because there are no values to return. What would be the easiest way to add Hour 5 and Hour 6 to the query's recordset with a corresponding value of zero for each hour? The trick is, from month to month, the hours that have no values might change. Any idee-ers? Thanks, Che. HOURTOTALORDERSPERHOUR 0 5 1 5 2 4 3 2 4 2 7 3 8 2 9 10 10 7 11 7 12 3 13 5 14 11 15 10 16 6 17 13 18 7 19 13 20 9 21 16 22 11 23 14 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216473 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Mark, that's what I thought. I tried to find a simple solution using the db, but I don't think it's going to work very well. Thanks, Che. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 8:47 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Che, If you are going to use isNull in this case you will need an ugly case statement inside your query. Even then, I'm not sure it's possible. You can wrap it in a stored proc and do some looping to return a temp table. If all you are doing is displaying this data in CF I would just loop from 0 to 23 and tease out the values rather than try to insert placeholders into the data. -Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Event Gatways: session scope?
Thanks for the reply Damon. That is what I had assumed, but I have made an application.cfm page with the cfapplication tag and session managment turned on, but it doesnt seem to hold any session values. Anything I should look for? Also, since it isnt a request over the internet, and there is no way to pass and get cfid and cftokens, how does it/would it keep track of the sessions? based on username? On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com [EMAIL PROTECTED] wrote: Yes, both session scope and client variables are available to you in Event Gateway apps, including the IM gateways as well. Check out Chapter 44-48 in the Developing Apps book for an excellent tour and walkthrough of building Event Gateway apps. Good stuff and well worth the read. Just enable session variables and/or client variables in your app as you would for a web app and things should work fine. Damon Hey guys, Im just getting started with event gateways and trying to figure out what I can and cant do. Is the session scope available in gateways? specifically the IM gateway? Regardless of the answer to the above question, is there a way short of datastore access that you can store values and retrieve them later based on who the gateway is talking with? I have tried a couple of different ways, which I can explain if needed, but no dice so far. I could also be looking over something in my code as well. Thanks for any response. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 Want gmail? Get it here while its hot. www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 7:50 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Mark, that's what I thought. I tried to find a simple solution using the db, but I don't think it's going to work very well. Thanks, Che. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 8:47 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Che, If you are going to use isNull in this case you will need an ugly case statement inside your query. Even then, I'm not sure it's possible. You can wrap it in a stored proc and do some looping to return a temp table. If all you are doing is displaying this data in CF I would just loop from 0 to 23 and tease out the values rather than try to insert placeholders into the data. -Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216476 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Che, I agree with Mark. Anything you do in the DB is going to be more complex than in CF in this particular case. I'd just do it in CF. If you need help with that code, let us know. Dave -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:04 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Huh? Ya got me with that one Mark. Care to explain in detail? Also, would it be easier to use CF to insert the missing hours of the day and values of zero (if yes, what would be the easist)? I hate to use CF when I might be able to use the db... but were only talking about 24 rows of data. ~Che -Original Message- Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -Original Message- SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Yeah... I could use the help. I have an idea... but its probably NOT the best or most efficient way to do it in CF. Enlighten me, por favor! ~Che -Original Message- Che, I agree with Mark. Anything you do in the DB is going to be more complex than in CF in this particular case. I'd just do it in CF. If you need help with that code, let us know. Dave -Original Message- Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -Original Message- SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216480 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfftp/firewall issue
We're trying to use cfftp to connect to an ftp server with a pretty stringent firewall. The firewall is set up to allow access via a network password/login particular to the individual logging in. Obviously, this works fine when using some program like WSFTPPRO where you can configure the firewall login settings. However, is there any way to do this using the cfftp tag? There is an attribute called proxyserver that we've tried with no success; not sure we're using it correctly. Any pointers you can give will be much appreciated! This is a company box we're trying to get into (with full permission), it's just the corporate server guys have the firewall locked down so far and don't want to open it up. Thanks! Shawna ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Count Question...
ms-sql, basically want to get the proper number of records. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216482 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Count Question...
I've never seen the 'id' = opportunity.id syntax before. Of course, I
don't use sql server. Do you get the same if you do select
opportunty.id AS id?
On 8/26/05, Protoculture [EMAIL PROTECTED] wrote:
I am trying to get a total count of all our records. The query itself is a
join ( as you can see below )... however when I make a change between the
following I get a different result set... I want to be able to return the
correct number of records but do it the correct way and not return a list of
ids ( then do a #queryname.recordCount# ), rather I just want a proper count
returned as I am trying to do in query2 below.
The two queries are identical except for the top portion, directly below.
query 1 snippet // this returns a listing 3500 records
SELECT DISTINCT 'id' = opportunity.id
/query 1 snippet
query 2 snippet // this returns a count of 135,000+ records
SELECT DISTINCT count(opportunity.id) as total_records
/query 2 snippet
/* also tried
count(*),
count(id = opportunity.id),
count('id' = opportunity.id)
*/
FULL SQL CODE...
query 1
SELECT DISTINCT
'id' = opportunity.id
FROMopportunity,
advertiser,
location
WHERE opportunity.deleted
= 'N'
AND
opportunity.authorised
= 'Y'
AND
opportunity.active
= 'Y'
AND
opportunity.activate
= getdate()
AND
opportunity.deactivate
= getdate()
AND
opportunity.advertiser_id
= advertiser.id
AND
advertiser.deleted
= 'N'
AND
advertiser.suspended
= 'N'
AND
(
(0 = 0 OR levels LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0 OR levels LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')
) AND
(0 = 0 OR sectors LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')AND
(0 = 0 OR work_types LIKE '%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')
AND
(
0 = 0 OR
(0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' +
'%' AND
0 LIKE'%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')
)
/query 1
query 2
SELECT DISTINCT
count(opportunity.id) as total_records
FROMopportunity,
advertiser,
location
WHERE opportunity.deleted
= 'N'
AND
opportunity.authorised
= 'Y'
AND
opportunity.active
= 'Y'
AND
opportunity.activate
= getdate()
AND
opportunity.deactivate
= getdate()
AND
opportunity.advertiser_id
= advertiser.id
Re: SQL Count Question...
yes I've also tried 'id' AS opportunity.id ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216484 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
Huh? Ya got me with that one Mark. Care to explain in detail? Also, would it be easier to use CF to insert the missing hours of the day and values of zero (if yes, what would be the easist)? I hate to use CF when I might be able to use the db... but were only talking about 24 rows of data. ~Che -Original Message- Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark -Original Message- SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS TotalOrdersPerHour FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005 23:59:59') GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate) ORDER BY Datepart(hh,OrderDate) ASC ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216477 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IIS 6 VS Apache
Does svn export allow for updates? I don't want to check out the whole application everytime I update a file... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 7:57 AM To: CF-Talk Subject: RE: IIS 6 VS Apache Russ Any reason why you cannot do svn export to deploy the application without the subversion system files? Kola -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 25 August 2005 21:23 To: CF-Talk Subject: RE: IIS 6 VS Apache Well acl's won't work well here, because .svn folders are created in every folder of your application by the subversion client. You can expect me to go through hundreds of folders and set the acl on every .svn subfolder. The reason I suspect it's easier with Apache is because apache has a lot of different options for the config file, and I bet one of those directives will do just what I want... disallow access to .svn folders. IIS just has the GUI, which isn't very rich, and I don't remember any options anywhere for disallowing access to specifically named folders. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 4:09 PM To: CF-Talk Subject: RE: IIS 6 VS Apache What about doing things such as blocking certain directories... like for example I want to block the .svn directory from being accessible from the web. I haven't figured out how to do it in either Apache or IIS, but I have a feeling it's much easier in apache... That strikes me as a silly thing to say. If you don't know how to do it with either one, what is the basis for your feeling? If you have a specific directory that you want to manage with regard to IIS, you set ACLs on it appropriately. Just like you'd set ACLs on files in a SMB share. So, for people who have that experience - practically every Windows server administrator in the world - I suspect IIS is easier. If you don't know how to set ACLs, I imagine it's a toss-up. But honestly, you're putting way too much thought into this, I suspect. Either IIS 6 or Apache will do what you need them to do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216485 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tinymce file manager
Thanks, that is exactly what I was looking for. It works VERY nicely! http://www.webworksllc.com/cffm/ integrates with TinyMCE. On 8/26/05, Stan Winchester [EMAIL PROTECTED] wrote: Has anyone made a image/file manager for Tinymce? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
There's probably a number of ways to do it. Mine may or may not be the most efficient, but it gets the job done. do your query here...query name=query (or whatever) CFSET HourList = valuelist(query.hour) table tr tdHour/td tdOrder Qty/td /tr CFLOOP FROM=0 TO=23 INDEX=hour CFSET thishour = numberformat(hour,'00') CFSET hit = listfind(HourList,thishour) tr tdcfoutput#thishour#/cfoutput/td tdCFIF hit cfoutput#query.TotalOrderPerHour[hit]#/cfoutputCFELSE0/CFIF/td /tr /CFLOOP /table -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:16 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Yeah... I could use the help. I have an idea... but its probably NOT the best or most efficient way to do it in CF. Enlighten me, por favor! ~Che ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216486 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Indexing question
Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216487 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: IIS 6 VS Apache
By default IIS 6 won't serve an svn mime type as far as I know. I know I've had to explicity tell it to serve different mime types on setup. On 8/25/05, Dave Watts [EMAIL PROTECTED] wrote: Well acl's won't work well here, because .svn folders are created in every folder of your application by the subversion client. I don't know enough about Subversion to comment, but if that's the case you're probably better off with a general rule somewhere rather than using ACLs, yes. You can expect me to go through hundreds of folders and set the acl on every .svn subfolder. No, that would probably be an impractical approach. However, you could easily do exactly that with a batch file and cacls.exe. The problem with that approach would be that you may add new .svn folders in the future, and you'd have to rerun the batch file. The reason I suspect it's easier with Apache is because apache has a lot of different options for the config file, and I bet one of those directives will do just what I want... disallow access to .svn folders. To the best of my knowledge, there's no Apache directive that specifically allows you to block access to directories whose names match part of a URL pattern. However, you could rewrite URLs to get the result you desire, with Apache or IIS. Again, I don't know much about Subversion, but I think that it has a lot of Apache-specific functionality that you can enable, so you might want to use Apache just to get at that functionality anyway. IIS just has the GUI, which isn't very rich, and I don't remember any options anywhere for disallowing access to specifically named folders. I'm not sure what you mean by very rich - it provides all the functionality to manage IIS, and IIS has quite a few switches. However, you can manage IIS without the GUI, using either the Metabase Editor (IIS 5) or any text editor (IIS 6). All of the IIS configuration information is stored in the Metabase, which is just a big, ugly XML document with IIS 6. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Indexing question
Hmmm, this is a verity index yeah? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 15:24 To: CF-Talk Subject: Indexing question Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216490 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Indexing question
This worked by building a query, but I'm still curious if anyone else had any other ideas. Dave -Original Message- From: Phillips, Dave Sent: Friday, August 26, 2005 10:24 AM To: CF-Talk Subject: Indexing question Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Coldfusion Administrator API Question: Writing a Script for Clear Template Cache Now
Hello all, I'm looking for a way to programmatically perform the same action that the Clear Template Cache Now button does. The Clear Template Cache Now button is located in the CF Administrator under Server Settings-Caching and is situated at the bottom of the screen. I'd like to write a script that does the same action but I'm not sure what method to call and what .cfc I should be getting it from. Here's the frame I've tried to put together so far. It's taken pretty much directly from the Macromedia documentation. cfscript // Login is always required. This example uses two lines of code. adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(admin); // Instantiate the data source object. myObj = createObject(component,cfide.adminapi.serverinstance); /cfscript After this I pretty much don't know where to go from here. Any help would be greatly appreciated. Thanks, CS ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Indexing question
Yes, sorry, Verity, and using CFMX 6.1 Dave -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 10:32 AM To: CF-Talk Subject: RE: Indexing question Hmmm, this is a verity index yeah? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 15:24 To: CF-Talk Subject: Indexing question Hey folks, Okay, I have a table with fields that I want index, AND one fo the fields is a URL, except I don't want to index the URL itself, I want to index the CONTENTS of the url. So, I thought I could just do a CFHTTP and pull the contents and add them to the cfindex. However, it's not that simple since when I do a cfindex of custom type I have to include the query name and the index only indexes the query fields, but not additional content. Is there any way I can accomplish this? The only thing I have thought of is to build a new Query from the results of the DB query and CFHTTP and then index on that query. That seems like a lot of work for this, so I wanted to see if anyone had any ideas on how to do it? Thanks, Dave ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
I don't know about sql server specifically, but you could try syntax like select count(distinct(mycolumn)) from mytable or else you should be able to do select count(*) from (select distinct(mycolumn) from mytable) /t -Original Message- Subject: SQL Count Question... From: [EMAIL PROTECTED] Date: Fri, 26 Aug 2005 07:16:33 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=41929forumid=4#216470 I don't think you can use DISTINCT with an aggregate function like count(). Also, you didn't indicate anywhere in this e-mail which database server you're using. Are you doing the query just to get the count, or is it for some other purpose as well. There's nothing wrong with using #queryname.recordcount#. You could do the count() without the DISTINCT, but that may give you more than you are looking for. Maybe you could tell us the goal you're trying to accomplish and there might be another way to approach it. Be sure to include your SQL database type and version. Also, providing your error message is very helpful. Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Count Question...
Well, I've never seen that behavior then. But, I also don't understand what the heck you're trying to do with your query. You realize that 0=0 will always be true, right? So, when you have a where statement like 0=0 OR (0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' AND 0 LIKE'%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') You might as well just leave off the second half of it. The DB is going to say, oh, yah, 0=0...I don't even have to check that other half of the or clause. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216495 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Query Question...[hopefully]
works well. thanks so much. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 10:07 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] There's probably a number of ways to do it. Mine may or may not be the most efficient, but it gets the job done. . do your query here...query name=query (or whatever) CFSET HourList = valuelist(query.hour) table tr tdHour/td tdOrder Qty/td /tr CFLOOP FROM=0 TO=23 INDEX=hour CFSET thishour = numberformat(hour,'00') CFSET hit = listfind(HourList,thishour) tr tdcfoutput#thishour#/cfoutput/td tdCFIF hit cfoutput#query.TotalOrderPerHour[hit]#/cfoutputCFELSE0/CFIF/td /tr /CFLOOP /table -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:16 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Yeah... I could use the help. I have an idea... but its probably NOT the best or most efficient way to do it in CF. Enlighten me, por favor! ~Che ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216488 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
Actually, if you're using SQL server, this might work: select count(*) from (put all your SQL in here without the count(), just the select distinct) that might do it. -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:02 AM To: CF-Talk Subject: RE: SQL Count Question... I don't know about sql server specifically, but you could try syntax like select count(distinct(mycolumn)) from mytable or else you should be able to do select count(*) from (select distinct(mycolumn) from mytable) /t -Original Message- Subject: SQL Count Question... From: [EMAIL PROTECTED] Date: Fri, 26 Aug 2005 07:16:33 -0500 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=41929forumid=4#216470 I don't think you can use DISTINCT with an aggregate function like count(). Also, you didn't indicate anywhere in this e-mail which database server you're using. Are you doing the query just to get the count, or is it for some other purpose as well. There's nothing wrong with using #queryname.recordcount#. You could do the count() without the DISTINCT, but that may give you more than you are looking for. Maybe you could tell us the goal you're trying to accomplish and there might be another way to approach it. Be sure to include your SQL database type and version. Also, providing your error message is very helpful. Dave ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216496 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Count Question...
thanks RADEMAKERS, that did it... here is the working code.. SELECT COUNT(DISTINCT(opportunity.id)) FROMopportunity, advertiser, location WHERE opportunity.deleted = 'N' AND opportunity.authorised = 'Y' AND opportunity.active = 'Y' AND opportunity.activate = getdate() AND opportunity.deactivate = getdate() AND opportunity.advertiser_id = advertiser.id AND advertiser.deleted = 'N' AND advertiser.suspended = 'N' AND ( (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') OR (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) AND (0 = 0 OR sectors LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%')AND (0 = 0 OR work_types LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') AND ( 0 = 0 OR (0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' AND 0 LIKE'%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216497 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Get fields in an Access table
On 8/25/05, Claude Schneegans [EMAIL PROTECTED] wrote: Any recomandation? Sorry. On this subject I am just a consumer. Clueless and loving it :-) -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: CSS: image overflow in IE vs Firefox
Thanks for the offer of help Sandy. I ended up finding this page: http://www.evolt.org/article/Ten_CSS_tricks_you_may_not_know/17/60369/?f ormat=print Tip #4 worked beautifully for what I needed to do. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
FYI - he's write about the 0 = 0, it's useless to have that with your or's...the or's aren't even being evaluated and ultimately, it's going to keep you from getting the right data. Glad you got the count to work though. :) Dave -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:39 AM To: CF-Talk Subject: Re: SQL Count Question... thanks RADEMAKERS, that did it... here is the working code.. SELECT COUNT(DISTINCT(opportunity.id)) FROMopportunity, advertiser, location WHERE opportunity.deleted = 'N' AND opportunity.authorised = 'Y' AND opportunity.active = 'Y' AND opportunity.activate = getdate() AND opportunity.deactivate = getdate() AND opportunity.advertiser_id = advertiser.id AND advertiser.deleted = 'N' AND advertiser.suspended = 'N' AND ( (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') OR (0 = 0 OR levels LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) AND (0 = 0 OR sectors LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%')AND (0 = 0 OR work_types LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') AND ( 0 = 0 OR (0 LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' AND 0 LIKE'%' + ',' + CONVERT(VARCHAR,0) + ',' + '%') ) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216500 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Event Gatways: session scope?
Check out this area of the Developer's Guide for how ID's are created for
session and client variables (and a discussion of how scopes work in general
with Event Gateway apps):
http://livedocs.macromedia.com/coldfusion/7/htmldocs/1642.htm
Also check out the example Event Gateway app we ship with for example code:
{cfusion}\gateway\cfc\examples\menu
HTH
Damon
Thanks for the reply Damon.
That is what I had assumed, but I have made an application.cfm page
with the cfapplication tag and session managment turned on, but it
doesnt seem to hold any session values. Anything I should look for?
Also, since it isnt a request over the internet, and there is no way
to pass and get cfid and cftokens, how does it/would it keep track of
the sessions? based on username?
On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
[EMAIL PROTECTED] wrote:
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216501
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Event Gatways: session scope?
Just what I was looking for, Thanks Damon!
On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
[EMAIL PROTECTED] wrote:
Check out this area of the Developer's Guide for how ID's are created for
session and client variables (and a discussion of how scopes work in general
with Event Gateway apps):
http://livedocs.macromedia.com/coldfusion/7/htmldocs/1642.htm
Also check out the example Event Gateway app we ship with for example code:
{cfusion}\gateway\cfc\examples\menu
HTH
Damon
Thanks for the reply Damon.
That is what I had assumed, but I have made an application.cfm page
with the cfapplication tag and session managment turned on, but it
doesnt seem to hold any session values. Anything I should look for?
Also, since it isnt a request over the internet, and there is no way
to pass and get cfid and cftokens, how does it/would it keep track of
the sessions? based on username?
On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
[EMAIL PROTECTED] wrote:
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216502
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Adding a database driver
Hi, A client of mine has an installation of CFMX7 Standard which needs to communicate with a Sybase database on another server on the network. The Standard version of CFMX disables the use of the included Sybase driver. So I have downloaded JConnect, Sybase's JDBC driver, and installed it. I have attempted to follow both Sybase's installation and connection information carefully, but when I enter the URL and driver information into the CF Administrator, I get a suitable database driver cannot be found. While this sounds like a path problem, I haven't been able to discover what's wrong. Has anyone needed to install and use a separate JDBC driver in this manner, and do you have any insight? Any help at all would be greatly appreciated. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216503 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
You have to add the driver to the jrun path. I dont know about sybase, but for instructions on how this went for mysql 4.1, check this link: http://www.ryanguill.com/blog/index.cfm?mode=entryentry=C7BE3545-40CA-6D1C-8A6FDADE72B840CC It may offer some clues. On 8/26/05, Tom McNeer [EMAIL PROTECTED] wrote: Hi, A client of mine has an installation of CFMX7 Standard which needs to communicate with a Sybase database on another server on the network. The Standard version of CFMX disables the use of the included Sybase driver. So I have downloaded JConnect, Sybase's JDBC driver, and installed it. I have attempted to follow both Sybase's installation and connection information carefully, but when I enter the URL and driver information into the CF Administrator, I get a suitable database driver cannot be found. While this sounds like a path problem, I haven't been able to discover what's wrong. Has anyone needed to install and use a separate JDBC driver in this manner, and do you have any insight? Any help at all would be greatly appreciated. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SQL Count Question...
Who you talking about he. I'm a she. ;) But, I am glad to see you agreeing. I thought for a minute there that I must have been confused if he got it to work with those statements in there. On 8/26/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: FYI - he's write about the 0 = 0, it's useless to have that with your or's...the or's aren't even being evaluated and ultimately, it's going to keep you from getting the right data. Glad you got the count to work though. :) Dave ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Query Question...[hopefully]
Actually what Mark Kruger said would probably work best in this situation Che, try this, create a table 1 row and the numbers 0 through 23 in them, then do a left join to your group by query :) -Mark What he's saying is create a table called Hours with column row called hour add 23 rows (0-23) and then left join your query to that query. select * from foo, goo where foo.hour = goo.hour(+) That will return all the hours from the hour table. Not complex at all. On 8/26/05, Che Vilnonis [EMAIL PROTECTED] wrote: works well. thanks so much. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 10:07 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] There's probably a number of ways to do it. Mine may or may not be the most efficient, but it gets the job done. . do your query here...query name=query (or whatever) CFSET HourList = valuelist(query.hour) table tr tdHour/td tdOrder Qty/td /tr CFLOOP FROM=0 TO=23 INDEX=hour CFSET thishour = numberformat(hour,'00') CFSET hit = listfind(HourList,thishour) tr tdcfoutput#thishour#/cfoutput/td tdCFIF hit cfoutput#query.TotalOrderPerHour[hit]#/cfoutputCFELSE0/CFIF/td /tr /CFLOOP /table -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 9:16 AM To: CF-Talk Subject: RE: Quick Query Question...[hopefully] Yeah... I could use the help. I have an idea... but its probably NOT the best or most efficient way to do it in CF. Enlighten me, por favor! ~Che ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216506 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
Hi Ryan, On 8/26/05, Ryan Guill [EMAIL PROTECTED] wrote: You have to add the driver to the jrun path. I dont know about sybase, but for instructions on how this went for mysql 4.1, check this link: Thanks, but jrun isn't involved. This is an installation of Standard on a Win2003 server, using IIS. The technote suggests that the driver needs to be in the WEB-INF directory. I have placed a copy there, as well as in the main lib directory where the macromedia-drivers.jar resides. But still no luck. Thoughts? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
I thought about how i said jrun afterwards and I knew that wasnt right. I meant the classpath, although thats what your lib should be. sorry, I dont guess I can really help much more than that. On 8/26/05, Tom McNeer [EMAIL PROTECTED] wrote: Hi Ryan, On 8/26/05, Ryan Guill [EMAIL PROTECTED] wrote: You have to add the driver to the jrun path. I dont know about sybase, but for instructions on how this went for mysql 4.1, check this link: Thanks, but jrun isn't involved. This is an installation of Standard on a Win2003 server, using IIS. The technote suggests that the driver needs to be in the WEB-INF directory. I have placed a copy there, as well as in the main lib directory where the macromedia-drivers.jar resides. But still no luck. Thoughts? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Multiple File Upload
All, Apart from looping through and outputting multiple forms (and via zip file) how are people handling multiple file uploads to a server? Any ideas/code/examples? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding a database driver
Even in standard version, jrun is involved, just not a full independent jrun. When I installed the Oracle jdbc driver on a MX6.1 standard I had to add the file the class path. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Count Question...
sorry, typo. I didn't look back to see who wrote what, just remembered it. Dave -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 1:14 PM To: CF-Talk Subject: Re: SQL Count Question... Who you talking about he. I'm a she. ;) But, I am glad to see you agreeing. I thought for a minute there that I must have been confused if he got it to work with those statements in there. ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfopenbb
Any updates on this effort? The initial buzz seems to have died down. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
On 8/26/05, Ian Skinner [EMAIL PROTECTED] wrote: Even in standard version, jrun is involved, just not a full independent jrun. When I installed the Oracle jdbc driver on a MX6.1 standard I had to add the file the class path. But if the file is enclosed within the same directory as the macromedia_drivers.jar, wouldn't it be within the class path? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
Apart from looping through and outputting multiple forms (and via zip file) how are people handling multiple file uploads to a server? I'm using the jupload java applet: www.jupload.biz/. I'm showing a first page allowing the user to select common attributes of the images and on the second page have the java applet which uploads the files. -- mack / ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfopenbb
I was on vacation when the intial emails went out and was unable to reply. I had assumed the fact that I hadn't heard anything further was due to my lack of response to the initial batch. I take it that's not the case? On 8/26/05, Tangorre, Michael [EMAIL PROTECTED] wrote: Any updates on this effort? The initial buzz seems to have died down. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216515 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding a database driver
A client of mine has an installation of CFMX7 Standard which needs to communicate with a Sybase database on another server on the network. The Standard version of CFMX disables the use of the included Sybase driver. So I have downloaded JConnect, Sybase's JDBC driver, and installed it. I have attempted to follow both Sybase's installation and connection information carefully, but when I enter the URL and driver information into the CF Administrator, I get a suitable database driver cannot be found. While this sounds like a path problem, I haven't been able to discover what's wrong. Has anyone needed to install and use a separate JDBC driver in this manner, and do you have any insight? Any help at all would be greatly appreciated. I haven't worked with Sybase drivers, but installing various drivers for MS SQL Server on CFMX Standard has simply involved putting the JAR file in \cfusionmx\lib, and putting the correct information in the Other datasource configuration screen within CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216516 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding a database driver
I couldn't tell you. I just followed the instructions I found on Macromedia.com for installing the Oracle JDBC driver, and it said add such and such string to the classpath. And the driver worked as advertised. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Multiple File Upload
Does multiple form fields count as multiple forms? That is what I do. Create an upload field, and a control that allows the user to add more fields as necessary. I understand there are tools out there that my allow more true multi-file upload, but I've never needed to hunt them down and figure them out. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: PhotoshopCS2 monitor profile messed up
Photoshop CS2 on Windows XP SP2... I've got two Samsung Syncmaster 151s monitors connected up and when I installed Photoshop CS2 it started complaining about the monitor profile being invalid. For a few days I clicked through the requestor when loading PS but today was tired of it so selected don't ask me this again. Then it seems I clicked the wrong button as now PS is incorrectly displaying colors, specifically everything seems to have a cyan-ish tone with white looking very strongly cyan. Any ideas on how to reset it? Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adding a database driver
But if the file is enclosed within the same directory as the macromedia_drivers.jar, wouldn't it be within the class path? If you add JAR files to \cfusionmx\lib (or \cfusionmx7\lib with CFMX 7 Standard), they should automatically be added to the classpath. Typically, JAR files must be manually added to the classpath otherwise, since a JAR file is essentially a directory (although a zipped one). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Multiple File Upload
hopefully this will go thru since all my recent posts are empty the problem is that you technically can only have 1 file.serverfile, so heres what i do in that case. make sure the file field isnt empty, do the upload give it a variable. !--- do the file 1 upload now --- cfif #form.pic1# NEQ    cffile Action=upload    filefield=pic1    destination=#uploads#    nameconflict=makeunique    accept=image/*    cfset pic1 = #file.serverfile# /cfif !--- do the file 2 upload now --- cfif #form.pic2# NEQ    cffile Action=upload    filefield=pic2    destination=#uploads#    nameconflict=makeunique    accept=image/*    cfset pic2 = #file.serverfile# /cfif ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Sent: Friday, August 26, 2005 1:37 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Multiple File Upload All, Apart from looping through and outputting multiple forms (and via zip file) how are people handling multiple file uploads to a server? Any ideas/code/examples? N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfopenbb
Any updates on this effort? The initial buzz seems to have died down. We're working--if you'd like to see things move faster, feel free to volunteer to help! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
The Stickman blog has a cool, cross-browser, single-form implementation that uses DHTML that I have not tried out yet. But there's a demo on the site and an explanation of how it works: http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element Take Care, Seth ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216523 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfopenbb
From: Matt Woodward [mailto:[EMAIL PROTECTED] We're working--if you'd like to see things move faster, feel free to volunteer to help! I wasn't criticizing, rather inquiring. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
I added my jConnect driver (jconn2.jar) to coldfusion/runtime/servers/lib and it works fine. Hope this helps. Hi, A client of mine has an installation of CFMX7 Standard which needs to communicate with a Sybase database on another server on the network. The Standard version of CFMX disables the use of the included Sybase driver. So I have downloaded JConnect, Sybase's JDBC driver, and installed it. I have attempted to follow both Sybase's installation and connection information carefully, but when I enter the URL and driver information into the CF Administrator, I get a suitable database driver cannot be found. While this sounds like a path problem, I haven't been able to discover what's wrong. Has anyone needed to install and use a separate JDBC driver in this manner, and do you have any insight? Any help at all would be greatly appreciated. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
.rtf/.html/.doc to .pdf under cf 5
Hi, is there any inexpensive way to convert a .rtf/.html/.doc-file under CF 5 to a .pdf-file ? ActivePDF is a bit too pricy. Uwe ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: .rtf/.html/.doc to .pdf under cf 5
[EMAIL PROTECTED] wrote: Hi, is there any inexpensive way to convert a .rtf/.html/.doc-file under CF 5 to a .pdf-file ? ActivePDF is a bit too pricy. you might try iText (free) but you know cf5 java ;-) ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: .rtf/.html/.doc to .pdf under cf 5
check out HTMLDOC www.easysw.com/htmldoc Jay On 8/26/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, is there any inexpensive way to convert a .rtf/.html/.doc-file under CF 5 to a .pdf-file ? ActivePDF is a bit too pricy. Uwe ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Request.dsn and flash remoting
I've got several CFC functions that are utilized by flash... When I have the datasource explicitly set FR works just fine. When I change the datasource to request.dsn, it stops working. Is there a best practices method for dealing with single location datasource updating when using flash? Thanks, Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: NLB and truncated responses from CF7
Is anyone using Win2K3 NLB with Apache and Coldfusion? Should I try switching to IIS? Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 -Original Message- From: Brandt, Chris M. Sent: Thursday, August 25, 2005 5:12 PM To: CF-Talk Subject: NLB and truncated responses from CF7 If this post appears in multiple locations, I apologize - it wasn't showing up in the list after a 'reasonable' amount of time when I tried to use the web posting feature. J -- I've got a single server running Win2K3 and set up using NLB. (I have another server ready to attach to the cluster, but figured I would get it going with the first node before going for both.) I'm running apache 2.0.54 and CF7 (updater 3) From my development machine: * When I attempt to access any pages from the server directly, everything works fine. * When I try to access NON-CF pages through the cluster address, everything works fine. * When I try to access CF pages through the cluster address, I get intermittent truncated results and an occasional The document contains no data from Firefox and Cannot find server pages from IE (despite the fact that it loaded part of the page, displayed it, and then displayed the error... As a test, I copied the generated html source (from a representative CF page) into a htm file and I can access that without any difficulty from the cluster address. Thanks for any insight. Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216530 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
cfif #form.pic1# NEQ This doesn't need the #'s. It should be: cfif form.pic1 NEQ Same here: cfset pic1 = #file.serverfile# Should be: cfset pic1 = file.serverfile Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216531 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adding a database driver
Thanks very much to everyone for their suggestions. Unfortunately, the replies add to my mystery. Dave, Thanks. That's what I figured. The file, jconn2.jar, is in the \cfusionmx7\lib directory, but I'm still getting the no suitable driver message. Alisa, I added my jConnect driver (jconn2.jar) to coldfusion/runtime/servers/lib and it works fine. I tried placing the .jar in this directory, too, but it didn't help. I'm using the following connection information, as provided by Sybase: URL: jdbc:sybase:Tds:localhost:2638 Driver Class: com.sybase.jdbc.SybDriver Although the final environment involves a Sybase Adaptive Server running on a separate machine, I'm trying to test locally using a Sybase Adaptive Server Anywhere test database. I have confirmed that the database server is running and the test database is accessible through Sybase's Sybase Central management utility. Alisa, is this the connection information you're using? Does any of this other information suggest a solution for anyone? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 530 Means St NW, Suite 110 Atlanta, GA 30318 404.589.0560 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server Instances and CF 7
You can set a DSN to use any instance you have installed, you simply name it in the DSN. -Original Message- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 12:20 To: CF-Talk Subject: SQL Server Instances and CF 7 I have a database that multiple sites are going to use and contains a substantial amount of data. Is there any way in SQL server you can make an instance of the database and allow different sites to hit the different instances keeping the sqlserver.exe from taking up too much cpu and memory? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216533 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
ok code meister! shouldnt u be trying to catch scam artists or something? hehe actually, (an believe me will you should do this as well with your spagetti code haha) I leave the pounds signs in so i can quickly find my variables and such, were as i don't it just takes longer and I dont have extra time on my hands like the wilbergini does ;)~ ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Will Tomlinson [EMAIL PROTECTED] Sent: Friday, August 26, 2005 3:43 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Multiple File Upload This doesn't need the #'s. It should be: Same here: Should be: Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Form Post From ASP.NET to CF not working
Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form Post From ASP.NET to CF not working
Connectivity issues? Perhaps you're hitting an error before the email is sent, due to the form fields not validating correctly? Matthew Small -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 3:59 PM To: CF-Talk Subject: Form Post From ASP.NET to CF not working Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216536 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Request.dsn and flash remoting
Where are you setting request.dsn? If it's in App.cfm then make sure that page is being called when you call the cfc. Do you run any logic that only works as expected when a browser requests pages? This might be hampering you attempts. Ade -Original Message- From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:11 To: CF-Talk Subject: Request.dsn and flash remoting I've got several CFC functions that are utilized by flash... When I have the datasource explicitly set FR works just fine. When I change the datasource to request.dsn, it stops working. Is there a best practices method for dealing with single location datasource updating when using flash? Thanks, Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form Post From ASP.NET to CF not working
This doesn't explain the random success of the process, but could the action attribute of the form be causing some issues? Can we see some code? Ade -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:59 To: CF-Talk Subject: Form Post From ASP.NET to CF not working Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216538 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Adobe Version Cue 2 uses MySQL!
Small thing I noticed. Adobe Version Cue v2 uses MySQL as the storage mechanism! Pretty funny if you ask me. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216539 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adobe Version Cue 2 uses MySQL!
why is it funny? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 3:28 PM To: CF-Talk Subject: OT: Adobe Version Cue 2 uses MySQL! Small thing I noticed. Adobe Version Cue v2 uses MySQL as the storage mechanism! Pretty funny if you ask me. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216540 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Form Post From ASP.NET to CF not working
Actually, the success is not that random - because the remote ASP.NET form stopped working some time after 5.45 AM today. It was working consistently yesterday when I was trying it. And right now, if I use the test forms we created both within our network and outside, it also works every time. I'm not sure which code you want to see - but because I don't have access to the remote form I can only give you the code I am using to send myself the test mail. The only code before this is in my Application.cfm. cfparam name=form default= cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=test form type=HTML cfdump var=#form# /cfmail Thanks, Caroline On 8/26/05, Adrian Lynch [EMAIL PROTECTED] wrote: This doesn't explain the random success of the process, but could the action attribute of the form be causing some issues? Can we see some code? Ade -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:59 To: CF-Talk Subject: Form Post From ASP.NET to CF not working Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216541 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form Post From ASP.NET to CF not working
Is your mail server having issues? Try explicitly stating the mail server. Matthew Small -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:35 PM To: CF-Talk Subject: Re: Form Post From ASP.NET to CF not working Actually, the success is not that random - because the remote ASP.NET form stopped working some time after 5.45 AM today. It was working consistently yesterday when I was trying it. And right now, if I use the test forms we created both within our network and outside, it also works every time. I'm not sure which code you want to see - but because I don't have access to the remote form I can only give you the code I am using to send myself the test mail. The only code before this is in my Application.cfm. cfparam name=form default= cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=test form type=HTML cfdump var=#form# /cfmail Thanks, Caroline On 8/26/05, Adrian Lynch [EMAIL PROTECTED] wrote: This doesn't explain the random success of the process, but could the action attribute of the form be causing some issues? Can we see some code? Ade -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:59 To: CF-Talk Subject: Form Post From ASP.NET to CF not working Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216542 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Request.dsn and flash remoting
You were right! I had an extra application.cfm in my components directory (testing something else) that was being called instead and so my request.dsn wasn't being defined! Thanks Adrian! Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 1:09 PM To: CF-Talk Subject: RE: Request.dsn and flash remoting Where are you setting request.dsn? If it's in App.cfm then make sure that page is being called when you call the cfc. Do you run any logic that only works as expected when a browser requests pages? This might be hampering you attempts. Ade -Original Message- From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:11 To: CF-Talk Subject: Request.dsn and flash remoting I've got several CFC functions that are utilized by flash... When I have the datasource explicitly set FR works just fine. When I change the datasource to request.dsn, it stops working. Is there a best practices method for dealing with single location datasource updating when using flash? Thanks, Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216543 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Adobe Version Cue 2 uses MySQL!
I'm used to any time an application needing to install a database layer it either being a custom thing, MSDE or MDB files. Discovering that MySQL is used was funny because a) it isn't one of the above, b) Adobe have a document management system so I kinda thought they were using a trimmed down version of it, c) MySQL isn't atomic therefore an odd choice. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:34 PM To: CF-Talk Subject: RE: Adobe Version Cue 2 uses MySQL! why is it funny? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 3:28 PM To: CF-Talk Subject: OT: Adobe Version Cue 2 uses MySQL! Small thing I noticed. Adobe Version Cue v2 uses MySQL as the storage mechanism! Pretty funny if you ask me. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Adobe Version Cue 2 uses MySQL!
MySQL is acutally used for a lot of embedded stuff. It's really modular, so it can be a very good choice, because you can get exactly the pieces you need. And it doesn't just run on windows, which both MSDE and Access are limited to. cheers, barneyb On 8/26/05, Damien McKenna [EMAIL PROTECTED] wrote: I'm used to any time an application needing to install a database layer it either being a custom thing, MSDE or MDB files. Discovering that MySQL is used was funny because a) it isn't one of the above, b) Adobe have a document management system so I kinda thought they were using a trimmed down version of it, c) MySQL isn't atomic therefore an odd choice. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ODBC nightmare
Hi, Is it really a problem with CFMX 6 ? When I define a DSN with the Windows ODBC manager, the CF Administrator does not list it, and when I define it through the Administrator, othe ODBC applications do not see it :-( This problem does not occur under CF 5. Is it fixed in CFMX 7? Thanks -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
JDBC nightmare
Hi, I'm trying to install a JDBC DS under CFMX 6.1 It's really a mess! :-( I succeeded to define the compassTravel example as described in the docs, but cannot manage to install any other DS on any other Access database, even scupuleously copiing the path name with same upper and lower case. Apparently one need to give this line in JDBC URL: jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/cfdocs/getting_started/db just to tell where the Acces C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd is. Why doesn't the Administrator just take C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd and does whatever needs to be done with it? Another thing is the driver class which need to be com.pointbase.jdbc.jdbcUniversalDriver How can I guess what are the other classes, and I suspect the other drivers available? My question, is this mess any better under CFMX 7, and is it worth upgrading? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Form Post From ASP.NET to CF not working
I tried that and it didn't make a difference. I also tried instead of sending an email to write a test file to the same directory and that worked with our forms but not the remote form. I asked our administrator to check exception logs, the mail server, etc. and there are no errors or problems as far as he can see. Thanks, Caroline On 8/26/05, Matthew Small [EMAIL PROTECTED] wrote: Is your mail server having issues? Try explicitly stating the mail server. Matthew Small -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 4:35 PM To: CF-Talk Subject: Re: Form Post From ASP.NET to CF not working Actually, the success is not that random - because the remote ASP.NET form stopped working some time after 5.45 AM today. It was working consistently yesterday when I was trying it. And right now, if I use the test forms we created both within our network and outside, it also works every time. I'm not sure which code you want to see - but because I don't have access to the remote form I can only give you the code I am using to send myself the test mail. The only code before this is in my Application.cfm. cfparam name=form default= cfmail from=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=test form type=HTML cfdump var=#form# /cfmail Thanks, Caroline On 8/26/05, Adrian Lynch [EMAIL PROTECTED] wrote: This doesn't explain the random success of the process, but could the action attribute of the form be causing some issues? Can we see some code? Ade -Original Message- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 20:59 To: CF-Talk Subject: Form Post From ASP.NET to CF not working Group, I have an application that is fed data from a form located on another server by way of doing the equivalent of a cfhttp post. The problem is that while there is a server log entry that the post occurred, my application does not get hit. For testing purposes I put a cfmail tag in the top of the page to send me a dump of all form fields received and when I submit the form I am not getting a message. But when I set up a test HTML form to submit form fields to my application, it worked and I got the message. The odd thing is - the vendor for the submitting form was updating some form fields last night and early this morning and when they were testing it then I received email messages with their test values. But, when I tried their form after I came to the office, no test emails were generated. I called them and asked them to try the form and they did - no test email. They insist they didn't make any changes to their end since the last time that I received successful test mails. I agree that it looks like the problem is on our end considering we have a server log entry, but the problem is - we did not change anything either, so why did it work this morning and not now? We have implemented this kind of process several times before with another vendor in CF and there was no problem whatsoever to connect... Any light shed on this conundrum would be appreciated Thanks, Caroline Wise ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tinymce file manager
Stan Winchester wrote: Thanks, that is exactly what I was looking for. It works VERY nicely! Thanks ;) - Rick Root ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Backup solution for small business?
It turns out John Cleese has put together an informative and timely Flash video on this subject. Stumbled across this today while eating lunch. I just barely avoided spitting my tuna sandwich all over the screen at one point. http://www.backuptrauma.com/video/default2.aspx -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Backup solution for small business?
You eat Tuna? Don't you know George Bush personally has injected Mercury into every Tuna Fish in the sea? Matt Robertson wrote: It turns out John Cleese has put together an informative and timely Flash video on this subject. Stumbled across this today while eating lunch. I just barely avoided spitting my tuna sandwich all over the screen at one point. http://www.backuptrauma.com/video/default2.aspx -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity questions
I am working on a modified version of my file manager that stores metadata about files and directories. My client wants to make the files searchable, and I'd like to search both the metadata (in a database) and the file contents themselves (txt, word, pdf, etc). I'm not entirely sure how to do this in a single verity collection though. Can I index the database content with the file content in a single collection and link the two? Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: NLB and truncated responses from CF7
Well you can try switching to IIS and seeing if the problem goes away... could it be mod_deflate? Perhaps the something is getting confused by the compression of the content and cuts off the page. I would try turning mod_deflate off and seeing if that fixes the problem. If not, try switching to IIS and see if that fixes it.. -Original Message- From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 3:15 PM To: CF-Talk Subject: RE: NLB and truncated responses from CF7 Is anyone using Win2K3 NLB with Apache and Coldfusion? Should I try switching to IIS? Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 -Original Message- From: Brandt, Chris M. Sent: Thursday, August 25, 2005 5:12 PM To: CF-Talk Subject: NLB and truncated responses from CF7 If this post appears in multiple locations, I apologize - it wasn't showing up in the list after a 'reasonable' amount of time when I tried to use the web posting feature. J -- I've got a single server running Win2K3 and set up using NLB. (I have another server ready to attach to the cluster, but figured I would get it going with the first node before going for both.) I'm running apache 2.0.54 and CF7 (updater 3) From my development machine: * When I attempt to access any pages from the server directly, everything works fine. * When I try to access NON-CF pages through the cluster address, everything works fine. * When I try to access CF pages through the cluster address, I get intermittent truncated results and an occasional The document contains no data from Firefox and Cannot find server pages from IE (despite the fact that it loaded part of the page, displayed it, and then displayed the error... As a test, I copied the generated html source (from a representative CF page) into a htm file and I can access that without any difficulty from the cluster address. Thanks for any insight. Chris ___ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
Will, You made a typo. You typed should when I'm sure you meant could (and your post added nothing to the discussion.. of course, neither does this one) Rick Will Tomlinson wrote: cfif #form.pic1# NEQ This doesn't need the #'s. It should be: cfif form.pic1 NEQ Same here: cfset pic1 = #file.serverfile# Should be: cfset pic1 = file.serverfile ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Multiple File Upload
Seth Bienek wrote: The Stickman blog has a cool, cross-browser, single-form implementation that uses DHTML that I have not tried out yet. But there's a demo on the site and an explanation of how it works: http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element Someone suggested implementing this in CFFM, which I may consider, it's pretty and much more user friendly. Of course, it still uses multiple form fields, technically. Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Backup solution for small business?
I pushed the third button! Matt Robertson wrote: It turns out John Cleese has put together an informative and timely Flash video on this subject. Stumbled across this today while eating lunch. I just barely avoided spitting my tuna sandwich all over the screen at one point. http://www.backuptrauma.com/video/default2.aspx -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
