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.
SELECT EXPIRATIONDATE
FROM COUPONS
WHERE EXPIRATIONDATE =
#data.RecordCount#
Thanks,
barry
~~~
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
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
>t
Thanks Alan.
I'll test it.
>It's not real or tested, but it should give you an idea how to do it.
>
>=]
>
>
>
>SELECT UserUUID, UserName
>FROM SomeTable
>WHERE
>UserName = value="#Form.userLogin#">
>AND
>User_IsActive = 1
>
>
>
>
>
>SELECT UserUUID, UserName
>FROM SomeTable
>WHERE
>UserUUID = va
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:
SELECT zip
FROM fddirectory
ORDER BY zip
This code does not work:
SELECT name
FROM fddirectory
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 m
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, i
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:
#ratings.fdd_name#
But this query does not work.
Barry
~
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:
>
>
>
>#ratings.fd
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 images
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.
h
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:
On the insert_action.cf
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
INSERT INTO artists(
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.
>
>
>
>
>
>
>or myImage.hei
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 cfse
Thanks Chad!
It worked.
Question...how do I add more input fields.
I would like to add this to my final code:
Final code that works:
#contacts.FirstName#
#contacts.LastName#
Action page:
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
INSERT player (con
I'm getting an error message.
I added this inside my CFFORM
Action page:
SELECT FirstName, LastName
FROM contacts
WHERE contactid = #FORM.player#
INSERT player (contactID, player, carpool_location)
VALUES (#FORM.player#,'#getFirstAndLast.FirstName# #getFirstAndLast.LastName#',
#FORM.carp
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:
SELEC
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)
SELECT a.zipcode, f.fdd_zip, f.fdd_name, a.IsPublished, a.IsActive, f.fdd_state
FROM articles a, fddirectory f
WHERE a.zipcode = f.fdd_zip
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.
SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev
FROMfddirectory F, states S
WHERE F.fdd_state =
AND F.fdd_state = S.abrev
ORDER BY fdd_na
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 ColdF
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:
>
>
>SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS
>FDCount
>FROM articles a, fddirectory f
>WHERE
Good Morning.
This code works below but I'm not sure if there is a better way. Please let me
know.
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 = LEFT(f.fdd_zip, 5)
AND f.fdd_state =
GROUP BY
Thanks Dave!
Here is your final code:
#story.fdd_name#
SELECT fdcount
FROM zip
WHERE zip.fdd_id =
(#NumberFormat(qZipCheck.fdcount)#)
Awesome.
Barry
~|
Want to reach the ColdFusion community
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:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/me
34 matches
Mail list logo
