Hello.
I was asked to help build a coldfusion website for a non-profit sport
organization to help speed up the process of online applications, schedules,
etc.
Does anybody know of a good website free or paid that has CF software for a
sport organizer.
Thanks,
Barry
I NEVER asked about hosting a website!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
Hello.
I'm using this log in form for my website but went a user types in the wrong
username or password, I would like to display an error message Sorry...wrong
username or Sorry...wrong password. As of now this form, if wrong, returns
back to loginform.cfm.
I just think it would be nice to
Good point...
Maybe I'll just say Wrong Paco
OK now for the dumb question.
Where do I add the code???
I just think it would be nice to tell the visitors what went wrong.
(Wrong username, password, or both).
I wouldn't recommend doing that. If someone is trying to gain illicit access
to your
Thanks Alan.
I'll test it.
It's not real or tested, but it should give you an idea how to do it.
=]
cfquery datasource=myDSNName name=variables.qCheckUN
SELECT UserUUID, UserName
FROM SomeTable
WHERE
UserName = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#Form.userLogin#
AND
User_IsActive =
Hello.
When I use this cf form below to autosuggest zip codes, it works great. But
when I try to autosuggest names, it does not work.
This code works below:
!--- Search ---
cfform action=results.cfm method=post name=search
cfquery name=ratings datasource=#dsn#
SELECT zip
FROM
Thanks...there is no Javascript.
Barry
Maybe there are Javascript-breaking signs in the names?
Just my 2 cents ;-)
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion
Yes..I have FireFox.
How do I use FF to debug?
Barry,
The CFFORM is using a javascript to make it work, if your results set
contains illegal characters in javascript, it would break your results.
Do you have FireFox and Firebug? Firebug has a great set of tools for
debugging javascript, it
How do you use Firebug to find a bad entry with a database table with over
25,000 records?
Barry
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
I think I found the problem.
In my Database, I found some entries like Acme # 1.
Because I have a large DB, how can I display only the names with the symbol #
in them.
For Example:
cfoutput query=ratings
cfif #ratings.fdd_name# CONTAINS #
#ratings.fdd_name#
/cfif
/cfoutput
But this query
Thanks !
Barry
I believe you have to do CONTAINS ## to escape the pound sign.
I think I found the problem.
In my Database, I found some entries like Acme # 1.
Because I have a large DB, how can I display only the names with the
symbol # in them.
For Example:
cfoutput query=ratings
cfif
Hello.
I was ask to help build a dynamic website for a volunteer fire department were
they could add news and photos. Iâm having trouble with the photos. Does
anybody know of a free or paid website were I can find some coldfusion code to
add, edit, update, and delete images. I would like to
Hi Rick.
I already tried googling cfimage but I have been unsuccessful in finding any
good CRUD with CF8 Images.
Barry
Yes, google cfimage and check out the google docs, etc.
After checking that out, let me know if you need any more
assistance understanding how to put it all together.
Any Help ?
I am still looking for an interface that allows me to add a new image record,
update a current image record, or delete a current image record with CF8.
Thanks,
Barry
~|
Want to reach the ColdFusion community with
I was ask to help build a dynamic website for a volunteer fire department were
they could add news and photos. Iâm having trouble with the photos.
I would like to be able to add, update, and delete or CRUD images to a database
(MySQL) and have CF8 crop the images too. Next, display the
Hi Rick...Thanks for your time!
Tony's link did not work and I sent him an email via his contact form. No reply
so far.
Here is an example of what I'm looking for but only that I want to add images
to the ArtistID. I understand all this code in this example. The problem is
with the images.
Hi Rick.
I started with this code below:
http://tutorial40.learncf.com/
I used two pages insert_form.cfm and insert_action.cfm
I added a field in the DB called image to the artists table
I also added a folder called user_photos
On the insert_form.cfm page I added:
cfform
Hello.
I was able to upload an image and add it to my DB using CF8 and MySQl this
weekend.
Can somebody tell me if this is correct. There are no error messages and the DB
is also correct.
Thanks
Barry
cfset thisDir = expandPath(images)
!--- Determine whether the form is uploaded with
Yes and Yes. The DB and the directory is perfect. I was just wondering if I was
leaving a temp image on the server every time I upload an image.
Hi, Barry...sorry I took so long to get back to you...busy weekend.
The code looks good as far as I can tell...the proof is always in the
results.
OK...last newbie question.
How do i add more than one photo to this code below. I added 4 new fields in
the DB called (image2, image3, image4, image5) and 4 more cfinputs with the
same names as the DB.
Thanks
Barry
This code below works when adding 1 photo.
cfset thisDir =
Hello Everybody.
I'm trying to build a form that only has one cfselect or drop-down menu option
on my website. Right now I have two cfselect but I would like to only display
the first cfselect (player). The second cfselect (contactID) I would like to
hide. The player selected in the first
Thanks Chad!
It worked.
Question...how do I add more input fields.
I would like to add this to my final code:
input type=text size=40 name=carpool_location /
Final code that works:
cfselect name=player size=1
cfoutput query=contacts
option value=#contacts.contactID##contacts.FirstName#
I'm getting an error message.
I added this inside my CFFORM
input type=text size=40 name=carpool_location /
Action page:
cfquery datasource=mydb name=getFirstAndLast
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
/cfquery
cfquery datasource=mydb name=insertPlayer
Hello Everybody.
I have been thinking and working on this for three days now. I'm looking for
some help totaling two fields from two tables.
Here is what I have:
Sample Tables:
Table - fdd_directory
fdd_name (Example: ACME Fire Dept)
fdd_state (Example: PA)
fdd_zip (Example: 12345)
Table
Thanks Barney B.
ERROR Message:
Syntax error or access violation: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right syntax
to use near 'select count(*) from articles where zipcode = fddirectory.fdd_z
Here is the cfquery:
I'm using MySQL 4.0.20.
Is there any other way to total these two fields?
Barry
What version of MySQL are you using? If it's a really old one that
doesn't support subqueries, check out the MySQL docs. They have a
section about rewriting subqueries into JOINs.
cheers,
barneyb
Thanks Barney!
The JOIN and GROUP clause might be over my head.
Do I use a RecordCount?
Barry
You just need a JOIN and GROUP BY clause. Check out the
subquery-to-join docs on MySQL's site. They have examples of how to do
exactly what you want.
cheers,
barneyb
I think I'm getting closer. This code below works but I don't know how to total
each fdd_name.
For Example:
ACME FD1 (38)
ACME FD2 (30)
ACME FD3 (20)
cfquery name=Zip datasource=#dsn#
SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state
FROM articles a, fddirectory
Hi Dave.
Thanks for the code!
Those two did not work.
I got two queries to work perfect but I don't know how to display them.
!---Get all data---
cfquery name=Story datasource=#request.dsn#
SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev
FROMfddirectory F, states S
WHERE
Here is the error message:
The string qZipTotals is not a valid ColdFusion variable name.
Valid variable names must start with a letter and can only contain letter,
numbers, and underscores.
Barry
~|
Want to reach the
Hi Dave.
I fixed the last error message. There was a space here:
name= qZipTotals
Now the data is displaying but it is not correct.
This code below (ZIP)is correct:
!---Count each fdd_name---
cfquery name=Zip datasource=#request.dsn#
SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state,
Good Morning.
This code works below but I'm not sure if there is a better way. Please let me
know.
cfquery name=Zip datasource=#request.dsn#
SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, f.fdd_id, count(f.fdd_id)
AS FDCount
FROM articles a, fddirectory f
WHERE a.zipcode =
Thanks Dave!
Here is your final code:
cfoutput query=story
#story.fdd_name#
cfquery dbtype=query name=qZipCheck
SELECT fdcount
FROM zip
WHERE zip.fdd_id = cfqueryparam value=#story.fdd_id#
cfsqltype=cf_sql_integer
/cfquery
cfif #qZipCheck.fdcount# GT 0
Hello.
I'm trying to get this cfquery to match a database field EXPIRATIONDATE(date)
2012-3-04 and do a recordcount but it is not working.
cfset mydatetime= DateFormat(Now(), '-mm-dd')
cfquery name=data datasource=mydata
SELECT EXPIRATIONDATE
FROM COUPONS
WHERE EXPIRATIONDATE =
34 matches
Mail list logo
