I am not sure how add a new thread. So I am posting this message here..
I am new user of CFMX and I am creating Login and Password page with Access as
Database. CAn anyone check as this CF script is ok:
cfquery name=Login datasource=Users
SELECT * FROM Login
WHERE Usr_Name = #form.Usr_Name#
AND
I am not sure how to add a new thread. So I am posting this message here..
I am a new user of CFMX and I am creating Login and Password page with Access as
Database. CAn anyone check as this CF script is ok:
cfquery name=Login datasource=Users
SELECT * FROM Login
WHERE Usr_Name =
Looks like you need to put single quotes around your #form.Usr_name# and
#form.User_Password# variables
cfquery name=Login datasource=Users
SELECT * FROM Login
WHERE Usr_Name = '#form.Usr_Name#'
AND Usr_Password = '#form.Usr_Password#'
/cfquery
other than that it looks ok to me
Greg Hamm
Thanks Heaps Grey..
I also want to know whether Coldfusion MX supports Microsoft Access 97??Because I am
having 97 at home and 2000 in office. It runs fine at my office but at home it is not
showing the datasource in admin page.
Can I keep your Email ID for furhter reference?
Sangeeta
I have this book and I really like it. It has explained OO
stuff in a way that I actually understood it. I have learned alot.
Just as a note, I would say that anyone who already has a grounding in
OO programming is not really going to get much out of Hal's book. I
received it last week and
Perhaps MM might take a clue from a long standing practice by Microsoft for
Registered users, and that is to send updater files via CD-ROM in snail mail.
This is not needed for small files and patches, but for updaters that are over,
say 5 MBytes in size.
=
You might want to switch your cfif statement. I think it is backwards. If
the recordcount is greater or equal to one that's a valid login, else if it
is zero, it was an invalid login.
Like:
cfif Login.RecordCount IS 0
cflocation url=invalidlogin.cfm?
cfelseif Login.RecordCount IS GTE 1
If the file is written to the filesystem when a change occurs, then CFMX _should_
recompile it upon execution. That shouldn't be a problem.
The question is _why_ would you want to make your code so inaccessible and inefficient.
-Original Message-
From: Barney Boisvert [mailto:[EMAIL
We've come across a very interesting issue here. We have several
applications that generate downloadable Excel spreadsheets or Word
documents. We're using cookies as part of our authentication/authorization
process and we're running CF 5 on Win2K Server.
The way were generating the document
Wouldn't you want to make that Login.RecordCount EQ 1. If you get more than
one record back you've clearly allowed duplicate user records and need to
take some action to correct that problem.
-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21,
well, not the login form, but the login prompt that is
thrown by the
web server. I do log on as B, and the browser seems to know
I'm B (the
cgi.auth_user variable has changed), but it looks like the query to
check and see if B is in my database never actually ran... which kind
of
Might not solve your problem, but had to do this to force a download in
a previous project
!--- IE 5.5 has bug and need to give it slightly diff header info ---
cfif FindNoCase(MSIE 5.5,CGI.USER_AGENT) GT 0
cfheader name=content-disposition
value=filename=#sFileName#
cfelse
Christian,
You are also forgetting those who can't download it to our workstations
because we work in corporate environments with locked-down workstations (I
can't imagine that I'm the only one in that situation). I can't install
the latest version of anything without rights. If I did update
Can you describe how you set up your web based security? I mean your
web
server settings to enable this.
I'm not the server admin, so I can't tell you exactly what's up. All I
know is that they're using Novell and net id what I do not know
is if net id is what the thing is actually
Use the record ID and not the product name in the dynamic var names
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
I don't know if this is a bug, undocumented feature or correct behavior?
But has anybody run into this before?
I have some code such as this in a CFC creating an array of queries.
!---
***
Pseudo code example
***
---
cfset QueryAry =
cfquery name=Login datasource=Users
SELECT * FROM Login
WHERE Usr_Name = '#form.Usr_Name#'
AND Usr_Password = '#form.Usr_Password#'
/cfquery
cfif Login.RecordCount EQ 0
!---INVALID---
cflocation url=invalidlogin.cfm?
cfelseif Login.RecordCount EQ 1
!---VALID---
cflocation
In my application.cfm file, I have the following:
cfapplication clientmanagement=yes sessionmanagement=yes name=myApp
!--- If you're not logged in, you step inside this code block ---
cflogin
!--- First, I'm checking to see if the login form variables exist.
Client validation makes sure
Strange behavior with CFdump.
I wrote some code something like this.
cftry
cfquery
.../cfquery
cfcatch type=database
cfmail to=[EMAIL PROTECTED]
from=[EMAIL PROTECTED] subject=Database Error
cfdump var=#cfcatch#
I'm guessing cfoutput query= doesn't evaluate the string correctly.
You have already found a workaround though, just don't use output
query=. Use the wishform to log a bug for this.
===
Raymond Camden, ColdFusion Jedi Master for
I've got a JavaScript that takes the selection from the first pull down menu
and populates the second pull down menu based on the first. The Script works
fine and give the result page it's suppose to after submitting the form. The
problem is, when you hit the back button, the first pull down
you probably need to set your var LoggedIn in the session scope. This wil make the
var available throught the session. the variables scope exists in the cfm page only.
cfset session.LoggedIn = 0
(mind your cflocks though)
Doug
-Original Message-
From: Jeff [mailto:[EMAIL
Set it as session.loggedIN Once you change the page you are no longer
executing the query, which means you are not setting the variables again.
That's why they never exist.
Eric
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:01 AM
To: CF-Talk
This sounds like the exact same issue I was having trying to use cflogin
with integrated windows authentication on IIS 5. The issue seemed to be
resolved in updater 2.
--Nathan
~|
Archives:
Maybe cfdump turned on cfsetting enablecfoutputonly-true and forget to
turn it off? It should _not_ have done that though.
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia
http://www.aida32.hu/aida32.php
Check out this product, it has all the information you could ever need about
the machine you are working on.
Windows only.
M
-Original Message-
From: Robert Shaw [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 3:41 PM
To: CF-Talk
Subject: OT:
It's possible, although after updater 2, the CFDUMP tag's source was
encrypted, so you can't tell for certain. If you haven't updated, you can
check the source.
/opt/coldfusionms/wwwroot/WEB-INF/cftags/dump.cfm
barneyb
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
LoggedIn will NOT be defined if you try to login and fail. Notice your
error msg branch doesn't set loggedIn to 0?
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia
Are there any DHTML drop-down menus that can align their respective submenus
automatically?
I know this has been covered many times before, but I've looked through the archives
and didn't really find what i'm looking for:
We currently use milonic menus, but i want to dynamically generate menus
on 3/21/03 11:35 AM, [EMAIL PROTECTED] at
[EMAIL PROTECTED] wrote:
you probably need to set your var LoggedIn in the session scope. This wil
make the var available throught the session. the variables scope exists in
the cfm page only.
cfset session.LoggedIn = 0
(mind your cflocks
It's a browser limitation. When the back button is pressed, the 'onchange'
handler of the first dropdown isn't fired, so the second dropdown doesn't
have any options to be automatically selected. You might try putting a
script at the bottom of the page (within the BODY tags, after the dropdowns)
on 3/21/03 11:44 AM, Raymond Camden at [EMAIL PROTECTED] wrote:
LoggedIn will NOT be defined if you try to login and fail. Notice your
error msg branch doesn't set loggedIn to 0?
Yep, you're absolutely right. I kinda caught that as I was pasting it in,
and corrected it when I changed it to
I've had problems similar to this, I had a multiple select dropdown where whatever you
have selected dynamically is generated into another dropdown where you then choose one
as the main selection. Anyways, if you do that and hit the back button, the 2nd
dropdown is blank, not just defaulted to
I hope I haven't come across as trying to trivialize the issue. It is
certainly a problem, and I submitted a report to the web team as soon
as I saw the first post. I then ran into the problem myself, and
although downloading the updater to my workstation and then uploading
it to my server
Hello,
Just wanted to inform everyone that there is a new FAQ available for using the CFMX
Connector (aka wsconfig).
FAQ for ColdFusion MX connector configuration
http://www.macromedia.com/support/coldfusion/ts/documents/connector_install_faq.htm
You may want to set the value to false _above_ the cfif blocks, and only
turn it to true on a good login.
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia
If you're using just IE, take a look at the saveHistory behavior:
http://msdn.microsoft.com/workshop/author/behaviors/reference/behaviors/savehistory.asp
- Original Message -
From: [EMAIL PROTECTED]
Date: Friday, March 21, 2003 9:27 am
Subject: CF_CEO_Dynamic_Pull_Down_Menus Client
on 3/21/03 12:36 PM, Raymond Camden at [EMAIL PROTECTED] wrote:
You may want to set the value to false _above_ the cfif blocks, and only
turn it to true on a good login.
Okay, now I KNOW I'm doing something right...because that's exactly the
approach I took...
Who knows...one day I might
Does anyone know the steps of converting a standalone server (CFMX) to use
IIS?
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:37 AM
To: CF-Talk
Subject: RE: Crud...I thought I had it down...[cflogin]
You may want to set the value to
We've got at least up through updater 2 installed on my server. I'm
not sure about updater 3, but I suspect yes.
-Patti
On Friday, March 21, 2003, at 11:42 AM, Nathan Mische wrote:
This sounds like the exact same issue I was having trying to use
cflogin
with integrated windows
I've seen something similar when I use cfdump while in a cfc. It
doesn't happen all the time... I never sat down to try and calculate
the variables, but things seem to go wrong when I'm 1) dumping in a
cfc, 2) Am dumping in the normal template that calls the cfc and the
second dump
Mark
Look at your C:\CFusionMX\bin\connectors for example and follow step 8.
Regards,
James Blaha
Below is an easy step-by-step configuration approach for windows web server
configuration. Applicable for IIS, Apache and iPlanet. Please ignore steps that do
not apply.
1) Stop your web
I believe read about this bug being fixed in the Release Notes for
Updater 3...
--
jon
mailto:[EMAIL PROTECTED]
Friday, March 21, 2003, 1:12:19 PM, you wrote:
PGLH I've seen something similar when I use cfdump while in a cfc. It
PGLH doesn't happen all the time... I never sat down to try
I know I can loop through form variables by using Form.FieldNames as a list,
but is there a similar ability to loop through the URL Parameter? (IE. I use
form action get instead of post).
I need this ASAP as I have to turn over a project today.
Thanks,
Rob
URL is a structure in CFMX, and CF5 as well, I believe. so you can use
structKeyList(url)
to get a list, or do a loop like this:
cfloop collection=#url# item=i ... /cfloop
barneyb
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Friday, March
cgi.query_string
This is a set of name and value pairs.
To break these into tokens, split them by the or ?, then look on either side of the
=
If you need more specifics, yell again.
Jerry Johnson
[EMAIL PROTECTED] 03/21/03 01:25PM
I know I can loop through form variables by using
This will point ya in the right direction (modify for your needs):
!--- create a list of URL variables and values ---
cfset keysToStruct = StructKeyArray(URL)
cfset URLList =
cfloop index=i from=1 to=#ArrayLen(keysToStruct)#
cfset URLList =
Rob,
You can use CFSCRIPT and PARSE the URL. Its a pain in the butt! I feel
your pain I just ran into this issue where I had a requirement to use
GET, do to an IE issue with a JavaScript reload to a Parent window from
a child window. My work around was in the end to just use a self
Thanks for all the help.
What I ended up doing was
cfif isDefined(URL.fuseaction)
cfloop collection=#URL# item=fname
cfif #Evaluate(URL. fname)# neq
cfset paramlist = paramlistfname =
URLEncodedFormat(#StructFind(URL, fname)#)
arrrgggEvaluate() is evil ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
Look at http://www.opencube.com/prod_quickmenupro.html
I have a developer's license and it was worth every penny.
M
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:56 AM
To: CF-Talk
Subject: SOT: DHTML dynamic drop down menus
Are there
Rob,
Just incase you want it this is what I did for the self submitting form.
Just add a input type=hidden name=submitFlag value=1 inside
your form for it to work.
CFIF IsDefined(Submit)
CFIF IsDefined(FORM.submitFlag)
CFLOCK SCOPE=SESSION TYPE=EXCLUSIVE TIMEOUT=10
!---
Instead of putting the script at the end of the document, wrap the code in a
function and call the function from the BODY's onLoad attribute.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
Hello All:
Just wondering what you all do out there for application lookup tables
for dropdown selection options. Do you use one table for all your
dropdowns and classify them or do you make a separate table for each
dropdown? Im not sure what the best route to go is.
For example a state
seperate tables...I've tried a universal lookup table with classifications
and it made FK relationships impossible in some situations...didn't like
that ;-)
If your universal tabel was huge the lookup for an individual select box
would take longer as well (more records = slower query)
Bryan
Separate tables, because you should be relating those tables to your main
tables in the DB. For example, for a user database where you also store the
user's state, you might have a DB design like:
Users xState
-
UserID
Tyler wrote:
with milonic, you have to give a height to each submenu to tell them
where to
start from the top of the browser.
No, that's not correct. Milonic aligns its own sub-menus as needed,
including jacking them up when they'd otherwise run off the scrn, just
like Windows menus.
See it in
If it's not related to other information in the database and don't change,
I'd put them into a file (CFM, TXT, XML, whatver) and then cache them in the
APPLICATION scope. If it's not even application dependant (like states),
then put it in the SERVER scope. If it's application dependant data
CF'ers
Thank you all for your fast posts! Thats what I was thinking but it's
always nice to hear it from others!
Have a great weekend!
Regards,
JB
Mosh Teitelbaum wrote:
Separate tables, because you should be relating those tables to your main
tables in the DB. For example, for a user
Have you looked at HeirMenus ???
http://www.webreference.com/dhtml/hiermenus/
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
Well, then... that would be very nice.
-Patti
On Friday, March 21, 2003, at 01:25 PM, jon hall wrote:
I believe read about this bug being fixed in the Release Notes for
Updater 3...
--
jon
mailto:[EMAIL PROTECTED]
Friday, March 21, 2003, 1:12:19 PM, you wrote:
PGLH I've seen
Joshua wrote:
Have you looked at HeirMenus ???
Have you *priced* Hiermenus?
It stopped being free about a year ago. Its been discussed here and elsewhere that
they've quoted prices in the US$1500 range for a commercial site. For that site I
mentioned earlier, a non-profit organization, they
WOW - I didn't realize it was THAT pricey. Huh, it must have been quite
a while since I've used them.
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
Back when we I implemented HeirMenus on an old site, it cost $500 to deploy
it without any mention of the author anywhere. If you left the author's
name in the JavaScript source blocks and a short URL as to where to download
HeirMenus, it was free. I'll have to see if that acknowledgement clause
I am trying to implement site-wide error handling on a fusebox 3 site and am
having a problem. The site is working just fine. However, I am simulating
the database being down by turning off execute rights to a stored procedure on
MSSQL. This throws an error a nice error against which I can
If you want global handling on a FB3 site, I'd wrap the call to the core
file in 'index.cfm' with a CFTRY and then you can have multiple CFCATCH
block to handle the different error types. Or you can just have one general
one.
I usually have something like this:
cftry
cfinclude
Please share your experience. I'll compile it if is is justifiable.
Thanks.
Don Li
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
I was told - and this was in first few months after internet.com had taken the rights
to Hiermenus over - that they were going to apply the terms retroactively, even to
sites using the product where the licensing agreement stated free use. How they
planned on not getting laughed out of a court
No, that does not work, maybe, the pound sign (#) wasn't interpreted correctly. IE6
STYLE
.sHistory {behavior:url(#default#savehistory);}
/STYLE
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
I am helping a group launch a regional job site.
Is there any code available to create a quick and dirty site?
Employers and job seekers will each have a section of the site to manage
their respective stuffs. Looking for something that is well designed and
extensible.
I do not have any
Interesting - I'll have to tell the people for whom I implemented HeirMenus
that they might have to look out for that, thank you for the heads-up.
Oddly enough, I traded emails as well with Mr. Belesis about the licensing
terms, and got the keep my name in there and it's free directly from him.
I can't figure out why I'm getting an error on this. The ExtraDate variable
outputs as 30.
cfset ExtraDate = DateAdd('m', 1, CreateDate(Year(Now()), Month(Now()),
1))
select size=1 name=Date
cfloop index=X from=1 to=#DaysInMonth(Month(ExtraDate))#
cfset Date = Month(ExtraDate) '/' X
What was the error?
- Original Message -
From: Chunshen Li [EMAIL PROTECTED] (Don)
Date: Friday, March 21, 2003 1:16 pm
Subject: CF_CEO_Dynamic_Pull_Down_Menus Client Management ???
No, that does not work, maybe, the pound sign (#) wasn't
interpreted correctly. IE6
STYLE
Eric... not that I can help you, but I'm embarking on a similar regional
task and would be interested in any suggestions this thread generates...
I'm intending on using a sql-svr 2000 db with some security wrapped
around it
-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]
you're adding one but going from 1 to the number of days in the month, so it's
exceeded the last day of the month and failing. either don't add the one or goto the
number of days - 1
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003
sorry, didn't realize at first you were adding one to the month, but you are exceeded
the number of days in the month, so subtract one
-Original Message-
From: Turetsky, Seth
Sent: Friday, March 21, 2003 4:43 PM
To: '[EMAIL PROTECTED]'
Subject: RE: why error?
you're adding one but
No err. Almost everything in the FORM is dynamic, dynamic upon dynamic, maybe too
much for IE or any other browser to handle for that matter.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
I wouldn't worry about it. By now they must have had their wings clipped by an
attorney or three. That developer I mentioned had called her lawyer and the words
cease and desist and bad faith were flying around even at that early stage.
I'd think you'd have been among the first to be
Matt,
You're exactly right...some where down the line I got mixed up, but I just
tried it and now I've very happy.
Thanks big-time for spotting my oversight-
Tyler
- Original Message -
From: Matt Robertson
To: CF-Talk
Tyler wrote:
with milonic, you have to give a height to each
You might want to get on the FlashComm listserv at
http://chattyfig.figleaf.com
FlashComm rocks!
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
1-877-FIG-LEAF
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 12:11 AM
To:
There is a great company that has a ColdFusion base hiring management system called
recruit max. Check it out. http://www.recruitmax.com/
Regards,
James Blaha
~|
Archives:
I downloaded IBM JRE 1.3.0 to use with ColdFusion MX. I'm now getting some
errors: javax/crypto/a (classdef not found). Anybody else get this JRE
working with coldfusion mx? If so, did you have the same problems?
Any info is VERY much appreciated!!!
Kevin D.
Hi,
I just upgrade from Apache 1.3.27 to 2.0.44 cos the new ColdfusionMX Updater
3 seams to fixes some problem.
Surprise, this new configuration doesn't work.
My config is
Windows 2000 SP3
Apache 2.0.0.44 == it works
Php 4.3.2 == it works
CFMX updater 3
//
I just installed Updater 3 on Apache 2.0.44 on two servers this morning
without issue, so I know it works.
If you didn't already, you'll need to remove the previous apache connector
and the run the web connector script again, because apache 1.3 and apache
2.0 use different connector APIs.
HTH,
http://www.clickdoug.com hosts CF 5.0 on Linux with ODBC to SQL2000 DB
=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: Tim Laureska [EMAIL PROTECTED]
To:
It works thanks barneyb
Eric
-Message d'origine-
De : Barney Boisvert [mailto:[EMAIL PROTECTED]
Envoyé : samedi 22 mars 2003 00:47
À : CF-Talk
Objet : RE: Apache 2.0.0.44 with CFMX Updater 3
I just installed Updater 3 on Apache 2.0.44 on two servers this morning
without issue, so I know
i appreciate the information but I am looking for the application not the
hosting.
Eric
From: samcfug [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: job site options [ commercial message
Date: Fri, 21 Mar 2003 17:53:16 -0600
http://www.clickdoug.com
Upgraded to Oracle 8 and that helped
Jim Watkins
- Original Message -
From: Joe Eugene [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, March 15, 2003 7:22 PM
Subject: RE: Urgent need help!
The error is on CF5 and using an Oracle v7 driver accessing an Oracle DB
As much as I hate to mention things like this..
In a previous e-mail I mentioned that I had an issue with Coldfusion MX
crashing on a high hit site. At the time, Coldfusion MX was un-patched..
Yesterday I ran the ColdFusion MX Updater 2. and, is still crashing at
least three times a day..
On Wednesday, Mar 19, 2003, at 19:33 US/Pacific, Sean A Corfield wrote:
This is the 'infamous' page context bug and you are correct that the
Updater 3 Release Notes do not mention it. I don't know what the bug
number is but I'll look it up when I'm back online at work...
I've confirmed that
90 matches
Mail list logo