Hi Folks, i'm prepping for the cf exam and i'm lacking a good understanding
of the difference between client and session variables. It seems that they
both are capable of doing the same thing. When and why should/would i use
one or the other? What apps have you used client vars for and not
Hello everyone, i'm currently running a query that is returning some odd
results. I'm trying to get the total number of sales in each category for a
salesperson. The query i'm running is below. With the data i have right now
i would expect to get back 4 for the total of sales per category for
Hi Folks, i'm using the query below to pull back the total quantity that a
salesperson has sold for a desired month. For some reason the numbers for
each item seem to be being doubled. Right now each sales person has two days
of sales for the month with the first day having 2 sales in each
Appologies, i left out some important info - the CF code. Below is the query
output. i'm using cf's group by for the first time. so perhaps it's a lack
of understanding of it's use that is causing the trouble. i'm grouping on
the sales person's name because my query pulls back the total sales
Gang, given the date 8/8/2001, how would i use a regular expression to set
the variables for month, day, and year. I know what i need to do, but i'm
just not sure how to do it with a Reg Exp
month: the number before the slash
day: the number between two slashes
year: the number after the last
I-Lin, thank you for your observation. I tried to join the two, but i get a
SQL error. i used:
dn.user_id *= u.user_id
(get all data for a user's id only if it exists in the dn table - is that
right?)
and i get the error:
Query contains an outer-join request that is not permitted.
I'm not
Hello, i've been asked to build a CF app for a kiosk. i was wondering if
anyone could recommend a company to purchase the kiosk stand from and we
would also need to use a touch screen for input. Can anyone recommend a
source for a touch screen? Thanks.
jb
Hello, is there ever a reason to use cftransaction around a single query? I
currently use it around queries that are dependant on each other, but
another coder is using cftransaction around single queries. Just wondering
if this is correct or just a waste. thanks.
Hello, i'm running a stored proc that contains two queries. if the first
query runs and does not return records, i need to run the second query. Can
anyone tell me the equivilent of recordCount in Transact-SQL? Thanks.
~~
Structure your ColdFusion
Hello again, i'm currently building a process that runs a query, creates a
file with that queries contents and then runs another query that makes
changes to the database based on the success of the first query and the file
that gets written. If the file is successfully written, i can update
Hello, I have form that has a text field in it. if the user types in any
html code or other code for that matter, i want to be able to remove it. i
looked for a tag in the tag gallery, but i didn't find one. is there a built
in fuction that isn't in the book that i can use? thanks for the
I seem to be having a problem searching for a space using RegEx. This is
what i'm using:
cfif REFindNoCase([[:Alpha:][:Punct:][ ]], myString)
bad chars found
/cfif
but it doesn't find any of the chars i'm looking for if i include [ ]. If
i remove that part, it finds what i'm looking for.
Hello, i'm having some trouble using regular expressions. i read the book
and looked up examples, but unfortunately, i can't seem to solve my problem.
i've written code that checks to see if there is either a letter or a
punctuation mark in a string, but it's not returning results properly.
:]], myString, 1,
True)
cfif something.pos[1]
cfoutput
Characters found at position: #something.pos[1]#BR
/cfoutput
cfelse
No alpha characters or punctuation found.
/cfif
Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/
- Original Message -
From: John Barleycorn [EMAIL PROTECTED
hello, i've been working on this problem for a few days and i'm not having
any luck solving it so i was hoping someone could help.
i'm creating form fields from a query so i have dynamically created vars
that are passed to my next page. on the next page the vars are checked and
if there is an
Hello, i moved a template from a 4.0 server to a 4.5 server and now i get a
very strange error message. Can anyone tell me why i'm getting this error?
Thanks for the help.
the code that generates an error:
cfoutput query=categories
cfset tempCategoryName = Replace(TRIM(category_nm), , ^,
hello,
i have a list of dynamically created text boxes that are named with a string
that holds the value of id|name|dataType. on the next page i extract the id,
name and dataType of each item using cfloop on the FIELDNAMES list and
getToken on each part of the list extracted by the loop.
Hello, i need to pull records out of my database for one month and only that
month (default current month, but can be any month). I've tried using:
SELECT quantity_nb
FROM tblDailyNumbers nb
WHERE DateDIFF(mm, #CreateODBCDate(Now())#, getDate()) = 0
AND DateDIFF(yy, #CreateODBCDate(Now())#,
18 matches
Mail list logo