Correct me if I'm wrong (please) but in an SQL statement rather than using
GTE it should be =
like this:
cfif form.startyear is not
and Year = #form.startyear#
/cfif
/cfquery
Hope this helps
J
- Original Message -
From: Denton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent:
hey all,
good afternoon.
here is my director of operations and myself.
http://www.houseoffusion.com/users/index.cfm?RecordID=43
jay
~~
Structure your ColdFusion code with Fusebox. Get the official book at
cf talkers,
sorry i click on the wrong address when i sent this. i appologize. it was
supposed to go to cf comm.
sorry again.
Jay
- Original Message -
From: Jay Patton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 19, 2001 12:41 PM
Subject: another [photo]
hey
this should be at the bottom of all the posts. atleast it is for me.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
,
Price
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
tr bgcolor=#IIf(QueryNameHere.CurrentRow Mod 2, DE('E7'),
DE('99CC99'))#
that should do it
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: Joshua Tipton
if i was in control of the administrator my self i would have, however the
rest of the site works fine w/ the same DSN. (This site is not hosted by
us.)
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro
ok i hate access.
i use this to unlock this db but it wont work now does anyone else have another idea?
cfquery name=Unlock datasource=catlingalleries dbtype=ODBC
Select *
From ImageManager
Where lock=damnyou
/cfquery
thanks
Jay Patton
Web Design / Application Design
Web Pro USA
p
thanks guys/gals
i should have said that im not the host of this particular site so i cant
reboot and fix it or use the release button in the administrator either...
sorry about that.
i got it though
thanks again
(this is why i dont use access)
Jay Patton
Web Design / Application Design
Web
RodeoManager
WHERE Circuit = '#url.CircuitName#'
/cfquery
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code
username=#username#
password=#password#
SELECT *
FROM RodeoManager
WHERE CircuitID = #url.CircuitID#
/cfquery
thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original
-serif
size=1#contestants.LastName#, #contestants.FirstName#
(#contestants.City#, #contestants.State#)/font/td
td width=19%font face=Verdana, Arial, Helvetica, sans-serif
size=1#totalPoints#/font/td
/tr
/cfif
/cfoutput
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p
\INDEX.CFM
D:\64.224.42.213\PHOTOGRAPHS\..\INCLUDES\FOOTER.CFM CFInclude
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure
, and try the operation again.
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (12:1) to (14:23).
and the column is in the myWork table so what gives?
Thanks in advance
Jay Patton
Web Design / Application Design
Web Pro USA
).
and the column is in the myWork table so what gives?
Thanks in advance
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion
Date/Time: 04/11/01 13:29:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Thanks in advance,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
it is and i overlooked that,
thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Garza, Jeff" [EMAIL PROTECTED]
To: "CF-Talk" [E
bmit" value="Go"/form
/td
==query in dateRange.cfm==
cfquery name="GetWorkOrders"
datasource="#datasource#"
username="#username#"
password="#password#"
dbtype="ODBC"
SELECT *
FROM WorkOrderManager
WH
rrentRow#/center/font/td
td width="251"font face="Verdana, Arial, Helvetica, sans-serif"
size="1"#GetTotalPts.LastName#, #GetTotalPts.FirstName# font
size="1"(#GetTotalPts.City#, #GetTotalPts.State#)/font/font/td
td width="85"font face="Verdana, Arial, Helvetica
ice wether they have
two DIFFERANT Event's or not?
Could someone please help me out here. im trying to get ONLY Those that have two
differant EventID's in this table.
Thanks!,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROT
using HAVING COUNT (DISTINCT EventID) =2 still returns the same results as
w/o the DISTINCT part. doesn't make sense to me. this should return about 10
or 11 records and it returns close to 40 or 50.
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO
Sorry for the OT,
quick question,
does anyone know if the programs that are running in the task bar (by the clock) are
applications or are they running as background services?
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e
thank you!
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Dave Watts" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday,
ContestantManager.LastName, ContestantManager.City,
ContestantManager.State, ContestantManager.Age
HAVING COUNT (EventID) = 2
ORDER BY SUM (AdjPoints) DESC
/cfquery
Thanks in advance,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext
i tried that and it doesnt show any results at all
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Bob Silverberg" [EMAIL PROTECTED]
To: "
would it be wise to try a sub query with this? or no? does anyone have any
other ideas or suggestions?
Thanks much,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message
maybe this:
'Your Message to Mike was sent.'
instead of:
"Your Message to Mike was sent."
???
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "
what does your query look like? (qryUpEquip)
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Jones, Becky" [EMAIL PROTECTED]
To: "CF-Talk&qu
r.ContestantID
WHERE ContestantManager.Gender = '2' AND ResultsManager.NotAllAround = '0'
GROUP BY ResultsManager.ContestantID, ContestantManager.FirstName,
ContestantManager.LastName, ContestantManager.City, ContestantManager.State
ORDER BY SUM (AdjPoints) DESC
/cfquery
Thanks a TON!,
Jay Patton
Web Design / Applica
cffile action="write" file="yourpath\blah.htm"
output="
html
!-- rest of code --
/html
"
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Mess
someone correct me if im wrong but doesn't the "From= " line have to have a
valid email address such as: FROM="[EMAIL PROTECTED]" and cant have a
name like: FROM="JAY PATTON"? i think i ran into a problem like this a while
ago.?!?.
Jay Patton
Web Design / Ap
your user information on the mail server where your userid is kept would
have to have your first and last name in the info for it to send with your
real name.
otherwise it will replace that with your email address.
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p
tdCFOUTPUTcfif url.startRow NEQ 1a
href="javascript:history.go(-1)"b -- Back/b/a/cfifcfif
url.startRow + 0 LT QRYNAME.recordCountA
HREF="cfoutput-default2.cfm?StartRow=#Evaluate(URL.StartRow +
1)#"bNext -- /b/a/cfif/CFOUTPUT/td
/tr
/table
HTH
Jay Patton
Web Design / Application Desi
oops
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, Mar
?
here is the line:
2001-03-23 18:53:33 204.248.26.246 USR224042136 IPSWGW0001ATL2 64.224.42.136 21
[4922]sent /catalog/dbase.txt 226 360448 0 2625 - -
Thanks,
(P.S. sorry for the OT)
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL
forgot to add that im assuming that this means downloaded?
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Jay Patton" [EMAIL PROTECTED]
To: "
cfset DateNow = #Now()#
cfoutput#DateFormat(DateNow,"mm/dd/")#/cfoutput
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Dave Hannum" [EMAIL PROTECTED]
To: "CF-Tal
sorry jumped to the answer (the wrong one) too fast.
Larry's method works well
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Jay Patton" [EMAIL PROTECTED]
To: "CF-Talk" [E
that it outputs
properly there, however I still get this error on this report when I try to
run it.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Les Mizzell" [EMAIL PROTECTED]
To: "CF-Talk&qu
Try:
#DateFormat(InitialIntdate,"mm/dd/")#
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Michael" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wed
..net = network infrastructure machines and organizations
..com = commercial, for-profit organizations
..edu = educational (colleges universities ect...)
..gov = government types of sites
..org = usually non-profit, organizations
Jay Patton
Web Design / Application Design
Web Pro USA
sorry i must have miss understood the question.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Jay Patton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, Ma
t;
password="#password#" dbtype="ODBC"SELECT EmployeeID, EmployeeFName FROM
EmployeeManager WHERE EmployeeID =
#GetReport.EmployeeID#/cfquery#GetEmpName.EmployeeFName#/font/td
td width="9%"font size="1" face="Verdana, Arial, Helv
this might be happening?
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
differantly on my end at all so the reason i didnt get connected the first
time i guess ill never find out.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Sean Daniels" [EMAIL PROTECTED]
To
try this, in your INSERT INTO Statement VALUE should be VALUES with and "S".
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Savan Thongvanh" [EMAIL PROTECTED]
To: "CF-Tal
action="AddClient.cfm" method="post"
CF_EmbedFields
!-- REST OF FORM HERE --
/cfform
--
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFu
action="AddClient.cfm" method="post"
CF_EmbedFields
!-- REST OF FORM HERE --
/cfform
--
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
I would use SQL or MySQL for this NOT! Access
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Kortland, Brian" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, Ma
does anyone know the name of the file and where it is located on windows 98 that saves
all of the passwords that you type in and save through ie?
thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
Hello All,
quick question about linux, CF,MYSQL vs. Win 2k, CF, SQL 2k.
how does ColdFusion on Linux using MySQL differ from CF on win2K using SQL 2K? And are
there any draw backs on MySQL or Linux version of CF? (bugs ect... )
Anyone with info on this would be helpful!
Thanks,
Jay Patton
Web
tml
I just refresh the page a few times and it unlocks the DB.
Hope this is helpfull.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday,
sorry i forgot to add,
that code i sent you is from a page that i use called unlock.cfm and i just
run that page when the db gets locked.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: [EMAIL
Jon,
Thanks i figured that something like that was the problem but it wasnt a top
priority page so i thought i would just send it out to see what i got back.
Thanks a lot,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original
two that i can think of off the top of my head
www.4guys.com
www.registrars.com
(this only works in IE 5.5 )
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Michael" [EMAIL PROTECTED]
To
this is crap
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Brian Thornton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 05, 2001 1:59 PM
Subject: Zombo
na, Arial, Helvetica, sans-serif"
size="1"Total Points/font/b/td
td width="102"bfont face="Verdana, Arial, Helvetica, sans-serif"
size="1"Include in AllAround (Y/N)/font/b/td
/tr
/table
br
table width="590" border="0
anager.LastName, ContestantManager.City, ContestantManager.State
ORDER BY SUM (AdjPoints) DESC
/cfquery
ERROR:
Error Diagnostic Information
An error occurred while evaluating the expression:
#ResultsManager.ContestantID#
Error near line 9, column 169.
Thanks,
Jay Patton
Web Design / Applica
"1"bPlace/b/font/td
td width="251" bgcolor="#CC"font face="Verdana, Arial, Helvetica,
sans-serif" size="1"bName/b/font/td
td width="85" bgcolor="#CC"font face="Verdana, Arial, Helvetica,
sans-serif" siz
nope thats not me
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Javed Mushtaq" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 11:15 AM
Subje
cfset ContestantID = #LoopContestantID#
cfquery name="PutResults" datasource="#datasource#" username="#username#"
password="#password#" dbtype="ODBC"
INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, TimeTaken, Points,
AdjPoints, MoneyEarned, No
ff Paul N. Weinberg.)
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Great thanks ill check it out
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Roque,Carlos" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001
Couldn't you just point the DSN on the access side to the SQL db until the
change takes place?
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "river" [EMAIL PROTECTED]
To: "CF-Talk&qu
E),
occupying document position (294:4) to (298:4).
it worked fine the other day.
any ideas?
thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion
boy do i feel dumb. i was referring to a code snippit from one of the other
sites that i have used this on before, and it turns out that i overlooked
the final slash at the end of the path.
THANK YOU so much for pointing that out to me.
Thanks all,
Jay Patton
Web Design / Application Design
cfset CrappyEditor = FrontPage
i would sum it up by saying that, FrontPage SUCKS! (in my opinion) it adds
extra or useless html code all the time, i use dreamweaver instead.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
Thank you all,
i just got all of the post's for my question. i haven't been getting any of
my houseoffusion mail today but thank you all for your input.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message
rFormat(EventResults.TotalTime,"___.__")#/cfoutput
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
h
ying document position (1:1) to (3:23).
any ideas?
thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECT
ahh i see, thank you philip i will just convert it then.
Thanks,
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Philip Arnold - ASP" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PRO
otals ect but the gender's and the results are in two different tables does that
create a problem? (im not very familiar with joining tables but im more than willing
to learn if that will fix my problem.. but i need this done by today (BONUS and a
RAISE :) any ideas?
your help is much mu
nevermind everyone, i got some help on it but thanks anyways.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Jay Patton" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent:
ot; align="center" valign="bottom"
a href="Details.cfm?#URLToken#ItemID=#ItemID#CategoryID=#CategoryID#"img
src="images/#ItemPic#" border="0"/abr
font class="boldtext"a
href="Details.cfm?#URLToken#ItemID=
Great guys,
Thanks.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Chris Alvarado" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 15, 2001 10:49
has anyone ever seen this error? if so what does it mean? ive never seen it before...
Error:
Just in time compilation error
unknown parser error
The last successfully parsed CFML construct was a CFQUERY tag occupying document
position (1:1) to (1:8).
Thanks,
Jay Patton
Web Pro USA
no problem...
this works fine localy but not on the web. its reffering to this query.
pretty simple.
I have a feeling that this is a server error.
cfquery name="GetNames"
datasource="rodeo"
dbtype="ODBC"
SELECT *
FROM ContestantManager
ORDER BY Las
Sorry,
it was a server error. the server on my providers end had stopped responding.
Thanks for the help though...
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox
thank you all for your help, i got it figured out now.
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Nilesh Thesia" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 11:33 PM
RIED TOTALPTS but it says
its not a valid field in the table... so im at a loss now.
/cfquery
--
Thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox.
ults"
datasource="?"
dbtype="ODBC"
INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time, Points,
AdjPoints, Money)
VALUES (
'#RodeoID#',
'#EventID#',
'#ContestantID#',
'#Place#',
'#Time#',
'#Points#',
'#AdjPoints#',
'#Money#')
/cfquery
--
Tha
eAdjPts + SixthPlacePts + SixthPlaceAdjPts) as TOTALPTS
FROM ResultManager
GROUP BY '#GetName.ContestantID#'
/cfquery
--
Thanks again,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fuseb
if anyone can help me on this i would appreciate it
i was wondering:
cfif
A. i could convert an excel file to sql
elseif
B. i could convert an excel file to access (if at all) then to sql?
/cfif
Thanks much :)
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
either needs to be setup as the default page on the webserver or you could
use a redirect on the 'index' page.
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [E
James,
it is IE only and its an icon that is called favicon.ico and its kept in the
root directory of the website. im pretty sure that you can make these with
any graphics program, they are only about 16x16 px. big.
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
is anyone else haveing problems getting allaire.com to come up?
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http
does anyone know where i can find a shopping cart since allaire's site seems to be
down? it needs to be open source. and around $100 - $150. also i need to see a demo of
it first. can anyone point me to a different site?
thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
nevermind the site is back up, but could i still get an idea from someone as to where
else i can look?
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: Jay Patton
To: [EMAIL PROTECTED]
Sent: Friday, January 26, 2001 9
),
occupying document position (2:1) to (2:61).
this is my query:
!---
cfquery name="GetTotal" datasource="" dbtype="ODBC"
SELECT Sum(Total) AS OrderTotal
FROM StoreOrders
WHERE SessionID = #CFTOKEN#
AND Processed = 0
/cfquery
--
Thanks,
Jay Patton
Web
i changed the field "Total" to "Price" i noticed that was wrong but i still
get the same error. the data type is Currency (its an Access DB)
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Russel Madere&q
Thanks,
i might accually use this when i get the time to build my own cart. I'm
sure it will help.
Thanks again,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "t nelson" [EMAIL PROTECTED]
To: "CF-Talk" [E
with a SQL Database? as apposed to an Access
Database? i just dont like working with Access if i can avoid it.
Thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get
I'll bet you $10 your correct.
:)
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Cameron Childress" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 3:13 PM
Subject:
does anyone remember or know the chmod number to make a file readable writeable and
executable by everyone? i cant remember it
thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion
thanks but it ended up being that we had to put the site up on a SQL server
rather than a shared cfserver and that took care of the problem.
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Russel Madere" [EMAIL PROTECTE
(compatible; MSIE 5.01; Windows 98)
Remote Address: 199.2.139.183
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com
does anyone know how i can make this tag output 3 colors instead of 2?
tr bgcolor="#IIf(DirList.CurrentRow Mod 2, DE('E7'), DE('FAFAFA'))#"
thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
that will be downloaded by clients manipulated and then uploaded again.
but i would like them to keep the same file name (sort of) but just add a _v2, _v3
ect.. to the end of it? has anyone else ever dealt with this? or have any ideas? Your
help is much appreciated.
Thanks,
Jay Patton
Web Pro USA
help is much appreciated.
Thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http
ha ha ha i agree
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, January 15, 2001 10:44 AM
Subject: RE: OT: Vacations and being ba
1 - 100 of 116 matches
Mail list logo