I agree not only do they need to try and get classes into the colleges,
they also need to teach the capabilities to the web staff of the
colleges.
I took a class on web administration (required couldn't opt out even
though I've been doing this a long time), and I used CF for my final
project. Whe
I don't know if I totally agree with that.
Does the C# code follow best practices for C#?
When doing a comparison between two languages you should use best
practices for both languages.
After all for good code we should all use best practices. I was taught
that when using Java (not entirely dif
Wait...
Wouldn't that be Ray 2010.1, Ray 2010.2, Ray 2010.3?
:)
Steve
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Tuesday, June 22, 2010 4:58 PM
To: cf-talk
Subject: RE: Is it time for Adobe to Rebrand Cold Fusion? [spamtrap
bayes][spamtrap heur]
Why don't you use a hybrid... Drop the files in a directory, then when
it's that files turn, check to see if a file of the same name is in a
subdirectory called watermarked (or something like that). If it is just
serve up the watermarked file. If not have the process create the
watermarked file
(in this case www.domains.com) and have it redirect via a url to
www.domain.com. I just figured there must be a simpler way than to
create
another "site" in IIS to do this.
Che
-----Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Thursday, June 03, 20
As long as you own the incorrect domains.com you should be able to have
IIS do a re-direct to the proper address. You can re-direct an entire
url right in the interface. I've done it before but it has been a
while.
Steve
-Original Message-
From: Scott Brady [mailto:dsbr...@gmail.com]
I'm willing to help. Just let me know what you want me to do!
-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
Sent: Tuesday, June 01, 2010 11:31 AM
To: cf-talk
Subject: Homesite 9 project
I'll be updating Homesite to the latest (CF9) docs. If anyone has a
Oh and as a matter of preference (and for some code checking tools) I
hate it when tags are embedded in other tags.
I would re-write this as:
Personal
Steve
-Original Message-
From: Yuliang Ruan [mailto:yuliangr...@hotmail.com]
Sent: Thursday, May 27, 2010 4:24 PM
Not true about selected instead of selected="selected"
Selected works for HTML4, selected="selected" is for XHTML. It will
depend on what is being used, but HTML4 supports selected="selected" and
xhtml does not support selected. So in this case it is probably best to
use selected="selected"
St
umber per CF server, so on a dual-core Xeon, we used to do 15-20
connections, and the settings are per datasource, so you don't have to
worry about splitting them or load-balancing them across your
datasources.
----
From: "DURETTE, STEVEN J (ATTASIAIT)
Jason,
You stated that connections should be set at 5 * CPU cores, is that the
cores on the CF server or the SQL server?
Also... What happens if you have multiple data sources. Do you use the
same settings for each data source, or do you split that 5 * CPU cores
across the data sources?
Steve
...@gmail.com]
Sent: Thursday, May 13, 2010 1:38 PM
To: cf-talk
Subject: Re: Convert to number
That won't work, you'll get "100.00", not "10.00". Try
REReplace(my_number, "[^0-9.]", "", "all").
cheers,
barneyb
On Thu, May 13, 2010
Robert,
You shouldn't have to strip it in a perfect world, but the comma makes it a
string not a number according to ColdFusion.
Try this instead: $#numberFormat(val(my_number), "__.00")#
Might not work, I didn't test it.
Steve
-Original Message-
From: Robert Harrison [mailto:ro
Ok, I'm not starting a war or anything here...
I agree with Dave as to the fact that it doesn't happen in most cases.
But I believe it should. If you code something that uses underlying
code/structure/etc made by someone else and that code/structure/etc gets
updated due to security issues/etc, t
I think components still make the most reusable choice for things like
this.
I throw all my utility type functions into one cfc and call the correct
function according to what is required, even if no input is required it
still has the desired affect of doing xyz. These don't change often so I
nor
Shannon,
In some ways you are right, but for code reuse I still believe the
custom tag is the way to go.
Say you put the code in /webroot/myIncludes/myReusableCode.cfm.
Someone working in /webroot/Application1/SubApp1/report would have to
use either
or if
the /webroot is mapped correctly.
Usi
Mike,
I sent out another email with a link to an article about changing the
database collation.
Steve
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, May 12, 2010 10:10 AM
To: cf-talk
Subject: Re: SQLServer2005 and European dates
Thank you Steve, bu
On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) <
sd1...@att.com> wrote:
>
> Mike,
>
> SQL Server doesn't actually save the date in either format. It saves
it
> as seconds (milliseconds maybe) from a certain date (I believe
> 1/1/1900).
>
>
ebworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT) <
sd1...@att.com> wrote:
>
> Mike,
>
> SQL Server doesn't actually save the date in either format. It saves
it
>
00.000
Steve
-Original Message-----
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Wednesday, May 12, 2010 9:35 AM
To: cf-talk
Subject: RE: SQLServer2005 and European dates
Mike,
SQL Server doesn't actually save the date in either format. It saves it
as seconds (milliseconds maybe) from
Mike,
SQL Server doesn't actually save the date in either format. It saves it
as seconds (milliseconds maybe) from a certain date (I believe
1/1/1900).
The way it is displaying is based on the collation setting of the
Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
back li
If your custom tag doesn't surround anything, make sure you add this
line:
That way if you have programmers that self close tags (), it won't run twice.
Steve
-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com]
Sent: Tuesday, May 11, 2010 12:32 PM
To: cf-talk
Subject: Re:
If you have a newer Windows OS (Vista, Win 7, Win 2008), then you can
use powershell.
I know in some environments you can't install software (even if it's
free) because of company policies.
I did a search and the following, based off of combining a lot of
different articles, will create a file w
Nope. What I would do is convert the report to a webpage and pull the
data from the db.
-Original Message-
From: Stephen Hoskins [mailto:shosk...@andonia.com]
Sent: Friday, May 07, 2010 12:17 PM
To: cf-talk
Subject: Anyone done this before???
I have a pretty complex MS Access report th
bject: Re: DateAdd value different on different servers
Steve,
On Thu, Apr 22, 2010 at 8:47 AM, DURETTE, STEVEN J (ATTASIAIT) <
sd1...@att.com> wrote:
>
> I believe it is doing this because even though you are adding a
specific
> amount of seconds the system automatically knows
I believe it is doing this because even though you are adding a specific
amount of seconds the system automatically knows to make adjustments
based on its time zone or if it uses daylight savings time or not. So
even though you say ignore that, you can't because the system doesn't
ignore it.
Ste
Looks like one of the servers updated to DST and the others didn't.
Steve
-Original Message-
From: Tom McNeer [mailto:tmcn...@gmail.com]
Sent: Wednesday, April 21, 2010 1:55 PM
To: cf-talk
Subject: DateAdd value different on different servers
There's a simple answer to this one; it's
I've never been able to get the "link" tag to work with cfdocument.
Try this:
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Tuesday, April 06, 2010 6:20 PM
To: cf-talk
Subject: Re: SOT: external css not displaying
No becau
Any chance you moved to a Win 2008 server? We had a similar problem and
it turned out that after we set everything up Win2K8 re-secured a couple
of directories and there were security exceptions in the log.
-Original Message-
From: Larry Peery [mailto:lpe...@stfm.org]
Sent: Thursday, Ap
Will,
I've generally found that when this happens it is because the user had a
bookmark to the submitted form. I generally have my forms return to the
empty form if no data was submitted. Suddenly I was bombarded with log
entries about the file that deals with the submission was getting an
empty
Not knowing the exact logic, I believe you need to change to this.
Better yet:
Steve
-Original Message-
From: Orlini, Robert [mailto:rorl...@hwwilson.com]
Sent: Monday, March 22, 2010 11:51 AM
To: cf-talk
Subject: Does not contain dilema
I have a form with a field call "intype"
That sounds right.
-Original Message-
From: Roger Austin [mailto:raust...@nc.rr.com]
Sent: Friday, March 19, 2010 1:40 PM
To: cf-talk
Subject: Re: CF9 and MS SQL DSN Creation Errors
DURETTE, STEVEN J (ATTASIAIT) wrote:
> MS SQL 2005 and 2008 deny ip Connections by default, you have
MS SQL 2005 and 2008 deny ip Connections by default, you have to go into
the settings (don't remember how off the top of my head) and allow tcpip
connections.
-Original Message-
From: Christopher Stowell [mailto:christopher.stow...@yahoo.com]
Sent: Friday, March 19, 2010 1:34 PM
To: cf-
Remove all the quotes around the cfqueryparams. ColdFusion will deal
with the quotes for you when you use the cfqueryparam tag.
-Original Message-
From: Steven Sprouse [mailto:sspro...@ccboe.com]
Sent: Thursday, March 18, 2010 10:10 AM
To: cf-talk
Subject: Re: Data Parse error
I'm sor
Bryan,
You don't by any chance have a cfschedule tag in any of your code? Maybe
something is hitting code with a cfschedule tag to automatically recall the
page in 5 minutes.
That might explain why the second hit is always exactly 5 minutes after the
original call no matter what the time fra
riginal Message-----
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Wednesday, March 10, 2010 3:33 PM
To: cf-talk
Subject: RE: Phantom Scheduled Tasks
Bryan,
I normally save all of CGI/Form/URL.
The main CGI ones to look at though are:
Cgi.http_referer, cgi.http_us
Bryan,
I normally save all of CGI/Form/URL.
The main CGI ones to look at though are:
Cgi.http_referer, cgi.http_user_agent, cgi.remote_addr,
cgi.request_method, cgi.script_name
If cgi.remote_addr is the ip of the server then the server made the
call. User agent helps to see if it was the schedul
Hi all,
Got a problem trying to convert a many to many relationship to a grid.
There are three tables (defined below), and I need the output in a
certain way (also defined below). I've done this before, but for the
life of me I can't remember how.
Table 1 (Target_Stratifications):
Str
fthrow
in Event2 just after it started the report. This dumped the stack trace
to a
file. There was nothing before the call to Event2 besides the normal
Mach-II
event handling stuff.
Bryan
-----Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Wednesday, Marc
In event 2, put in something that saves off all the CGI/form/url
variables to a file before it does any other processing. Then you can
look at the file for the second run and see what kicked it off.
-Original Message-
From: Bryan S [mailto:bryansgroup...@gmail.com]
Sent: Wednesday, Mar
I'll raise my hand for this. I probably won't be able to do it all, but
if a few of us all work on it then it should get done pretty quick.
Let me know what I need to do.
Steve
-Original Message-
From: Michael Dinowitz [mailto:mdino...@houseoffusion.com]
Sent: Wednesday, March 10, 20
Hate to say it... Fix the database.
Fixing the database almost always shows a better speed increase and
processing than refactoring CF code. That is if the database is a mess
in the first place.
I've just started reading Joe Celko's SQL for Smarties, and in the first
chapter I've found stuff I'
Thanks this will help a lot I hope!
-Original Message-
From: Jacob [mailto:ja...@excaliburfilms.com]
Sent: Tuesday, March 02, 2010 10:30 AM
To: cf-talk
Subject: RE: Local Server Crashes - How to back up settings
What I backup..
In the ColdFusion directory:
\bin\neo-*.xml (Your CF Ad
Hi all,
So I still don't have ColdFusion working. I've decided to just reinstall
CF, but I need to back up all of the Admin settings. How can I do that
without ColdFusion running?
Thanks,
Steve
~|
Want to reach the
around.
~Brad
Original Message
Subject: RE: CF9 local dev server crashes.
From: "DURETTE, STEVEN J (ATTASIAIT)"
Date: Mon, March 01, 2010 3:04 pm
To: cf-talk
No changes to debugging at all. Even trying to hit the CFAdmin causes
it to crash.
-Original Message-
From: b.
anges to the debugging templates have
you?
What happens if you turn off request debugging?
Was there a previous install of CF on your machine?
~Brad
Original Message
Subject: CF9 local dev server crashes.
From: "DURETTE, STEVEN J (ATTASIAIT)"
Date: Mon, March 01,
Hi all,
I have a problem with my cf9 server on my local dev box crashing. Even
with the most simple ColdFusion page it crashes.
When I say crashes, the service stops working. I ran CF9 using
cfstart.bat just to see what is going on, and the results are below.
This was just working fo
As I understand it, Firefox shares cookies, etc across all instances of
Firefox.
IE however treats every instance as its own little world and doesn't
share well with itself.
Steve
-Original Message-
From: Chad McCue [mailto:ch...@icsciences.com]
Sent: Wednesday, February 24, 2010 1:16
Opps.
I used didn't put variables in this instance. I
wanted them to only be part of the cfc.
Steve
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Tuesday, February 02, 2010 1:50 PM
To: cf-talk
Subject: RE: difference between cfproperty and variables defined
According to the docs, cfproperty only sets Metadata. I just did this
recently and even though I could set the initial values I had trouble
changing them and using them just inside the cfc.
I resorted to Notice that there is no var
in there. If the variables are outside of a function, you can
JS file downloaded for me.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Monday, February 01, 2010 10:52 AM
To: cf-talk
Subject: Link test.
Can a few of you out there in CF-Talk land test this link and tell me if
you get the expect JavaScript file or something e
At the risk of making several assumptions
>
> if(getmetadata(wb).name == 'XSSFWorkbook') file += "x";
>
> ~Brad
>
> Original Message ----
> Subject: CF Equivalent of JAVA code.
> From: "DURETTE, STEVEN J (ATTASIAIT)"
> Date: Fri,
riday, January 29, 2010 2:27 PM
To: cf-talk
Subject: RE: CF Equivalent of JAVA code.
At the risk of making several assumptions
if(getmetadata(wb).name == 'XSSFWorkbook') file += "x";
~Brad
Original Message
Subject: CF Equivalent of JAVA code.
From: &quo
Hi All,
I'm trying to do some work and I have some java examples. For the most
part I can easily convert to CF, but I'm not sure how to convert this:
If(wb instanceof XSSFWorkbook) file += "x";
I don't know how to check if wb is an instance of XSSFWorkbook. Wb
could be XSSFWorkbook o
I don't know what CF9 is doing under the hood. What I do is put all the
queries in stored procedures. At the beginning of the procedure I always
put SET NOCOUNT ON and I always end with SET NOCOUNT OFF.
If you have a procedure that is doing a lot of stuff it can reduce a lot
of back and forth an
Use SCOPE_IDENTITY(). @@Identity returns the id for the last record
inserted. If an another insert into that table occurs between your
insert and the select @@identity (2 different people making inserts into
the db for example) you will get the id for the other record that was
inserted.
Scope id
All,
Nevermind, I was able to figure it out myself. Took creating a java
object.
Thanks though.
Steve
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Thursday, January 28, 2010 1:34 PM
To: cf-talk
Subject: Using POI and ColdFusion to output to browser instead of file.
Hi all
Hi all,
I'm trying to use the Apache POI to write an excel file to the browser.
I can generate the excel files no problem, but what I want to do is sent
the data directly to the browser without hitting the file system at all.
Sort of like using cfcontent with html. I want to use cfcontent
I don't know about that... I think it would be a perfect project for
Junior Engineers just starting in the group to get into.
Gets them deep into the code without having them do anything too complex
to begin with!
Steve
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
LOL!
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Monday, January 25, 2010 2:51 PM
To: cf-talk
Subject: RE: (ot) Adobe error messages
You only get Allaire errors because you code is really sucky.
Minor code problems get you Adobe messages.
Major code
I believe that you also have to add www.beta.solo.com to IIS. If the
site is using host headers (exclusively) and gets one that isn't defined
then it throws an error.
Steve
-Original Message-
From: Jeff F [mailto:cftalk_l...@fongemie.com]
Sent: Friday, January 08, 2010 10:22 AM
To: cf
CFMeetup just had a meeting on "Homebrewed ColdFusion Monitoring" by Wil
Genovese.
It was an awesome meetup and the recording can be viewed at:
http://www.meetup.com/coldfusionmeetup/pages/Recordings_of_the_ColdFusio
n_Meetup-2009/
Or at: http://experts.na3.acrobat.com/p34004904/
Also Wil has p
Ben,
Do an arraylen on the first row. arrayLen(myVar[1])
That will return the number of columns or planes.
Steve
-Original Message-
From: Ben Conner [mailto:b...@webworldinc.com]
Sent: Thursday, December 17, 2009 11:08 AM
To: cf-talk
Subject: array question
Hi,
Haven't played muc
ated? Any ideas why this may be the case?
Ian
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: 15 December 2009 16:54
To: cf-talk
Subject: RE: Basic user stats via Coldfusion
Ian,
This sounds like you should be looking at the webserver logs. If yo
Search through the data to get the largest length for the item in the
first column.
Then when you are doing your loop, do
Then output #Variables.myTempFirstCol#|#Variables.mySecondCol#
Since the first column will now be a fixed length everything should line
up.
Steve
-Original Message--
If CF is on a Windows box and you have access to cfexecute, Windows
servers come with a built in command line version of Zip.
If you can get to a command prompt just type zip /? And you should get
the available commands.
Then cfexecute what you need to.
Steve
-Original Message-
From:
Chad,
Tedious or not it is considered by many as a best practice to name your
columns.
Select * is the bane of my existence many times.
Steve
-Original Message-
From: Chad Gray [mailto:cg...@careyweb.com]
Sent: Tuesday, December 15, 2009 11:55 AM
To: cf-talk
Subject: copy from table
Ian,
This sounds like you should be looking at the webserver logs. If you
are using IIS, you can have it log the Windows Login info in the IIS
logs.
I don't know if Apache can or not.
Then you can use something like LOG Parser from Microsoft to search the
log files just like you would with a d
My .02...
If what is happening is being done on the database backend anyway, then
do the heavy lifting in the DB. That's what they are there for.
You could have CF kick something off on the DB that does something like
schedule a procedure to kick off in 30 seconds, then return a status
code for
I think that's right...
-Original Message-
From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk]
Sent: Thursday, December 10, 2009 9:43 AM
To: cf-talk
Subject: convert this cfscript back to tag?
Hi all,
could someone convert this cfscript back to tag?
All,
I'm having some cfform weirdness.
Occasionally, a user submits a cfform (flash form) and the following
page miss error gets emailed to me:
E:\JRun4\servers\NOTFORU2C\cfusion.ear\cfusion.war\CFIDE\scriptscfformhi
story.cfm
I see that the problem is a missing \ between scripts and
c
Well, Time for me to climb back down into the hole and hide my head! :)
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, November 13, 2009 3:37 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page
> That gives an error that my data must be bin
You may have to do toBinary(toBase64(yourVariable))
-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com]
Sent: Friday, November 13, 2009 3:25 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page
That gives an error that my data must be binary o
toBinary() ?
-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com]
Sent: Friday, November 13, 2009 3:25 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page
That gives an error that my data must be binary on the cfcontent. Any
other thoughts?
I don't fully remember but I believe that you have to wrap the data in
toBase64()
-Original Message-
From: Kim Hoopingarner [mailto:k.hoopingar...@e-details.com]
Sent: Friday, November 13, 2009 3:20 PM
To: cf-talk
Subject: Re: JPG in Database - Retrieve for web page
Thanks for the head
Actually, if MSSQL 2005+ is being used, PIVOT might come in handy here.
I had a procedure that used cursors. It ran for 2 minutes. I converted
it to use PIVOT instead and I get the same results in 2 seconds!
Steve
-Original Message-
From: Dave Phelan [mailto:dphe...@lifepoint.com]
Se
I'd say no. The end time is only if you want the job to run between
certain hours.
For example I have a job that runs every 5 minutes between 8am and 4pm.
Steve
-Original Message-
From: Agha Mehdi [mailto:aghaime...@gmail.com]
Sent: Friday, November 13, 2009 12:58 PM
To: cf-talk
Subj
All,
Ok, this is a little pet peeve of mine. We have session timeout set and
we tell users that they have to do something within so much time.
Problem is the users ignore that. They open a page with a form, leave
it open for an hour, then when they submit the form Session is invalid
erro
Quick and dirty fix...
In the processing page, add this to the top:
Steve
-Original Message-
From: Andy Matthews [mailto:li...@commadelimited.com]
Sent: Wednesday, November 04, 2009 1:16 PM
To: cf-talk
Subject: RE: Form Insanity
With radio buttons, checkboxes, and multiple select d
One reason could be Corporate policy.
I know one company for sure that will not be named that has a policy
that states that user id and password fields will be blank.
Even though they lock down the browser not to auto populate, some people
could still get past it. Then for some reason, the powe
I found the problem. Permissions. Permissions. Permissions!
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Monday, November 02, 2009 11:03 AM
To: cf-talk
Subject: CFForms don't display... Help!
All,
We moved from a CF7 server to a CF8 server this weekend. No
All,
We moved from a CF7 server to a CF8 server this weekend. Now the flash
forms will not display.
When I hit the pages I get an error: object expected Line: (what ever
line for that page)
When I choose to debug I get this:
Dave,
Thanks, we can always count on you. I actually came up with another way
as well. What you did inspired me.
The numbers range from 6 down to 1. I made a copy of the string and
replaced the 6 with A, 5 with B, etc. Then I can sort it ascending and
not worry about it. After its sorted th
All,
I have a strange situation. I have to sort a list twice. First by a
number, descending, then by text ascending.
I know sounds strange but here is an example.
Original list (example only real info stripped out):
2-CCC|2-AAA|2-DDD|5-ZZZ
First it has to be sorted by the number, s
Daniel,
Try this:
SELECT
a.passport_listing_id
,a.passport_registration_id
,a.email_sent_attendance
,a.s_uid
,a.student_id
,a.people_id
,coalesce(b.fname, c.fname) fname
,coalesce(b.lname, c.lname) lname
,coalesce(b
Daniel,
You didn't post a link to the data.
Steve
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Sent: Wednesday, October 28, 2009 8:47 AM
To: cf-talk
Subject: Re: SQL Join help needed
>OPPS...
>
>Change the on a.student_id = d.student_id to on a.passport_listing_i
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
Steve
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Tuesday, October 27, 2009 3:11 PM
To: cf-talk
Subject: RE: SQL Join help needed
Sorry about that... Try this
Sorry about that... Try this...
SELECT
a.passport_listing_id
,a.passport_registration_id
,a.email_sent_attendance
,a.s_uid
,a.student_id
,a.people_id
,coalesce(b.fname, c.f
If it's a version newer than oracle 8 I believe it can use either
notation but the newer form is suggested.
I don't remember which version they added this notation. I believe it
falls under the SQL92 standards.
Steve
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Se
This code isn't using inner/outer join notation, but the old style. Is
there a reason for this?
I would change the code to this:
SELECT
a.passport_listing_id
,a.passport_registration_id
,a.email_sent_attendance
,a.s_uid
Problem with that is when you are dealing with timing in less than a
second that can go wrong...
For example assume before you start an insert the max_id = 1. Then 2
people go to make an insert at the same time...
Insert A - max_id increments to 2.
Insert B - max_id increments to 3 (this inser
Yes, that is why my code set invoice = "".
Then set invoicenumber = line 26.
Go to line 27 if invoicenumber has a length then continue on, if not set
the invoice number to the value on line 27.
Ok, so my code didn't work... Is something else changing invoice number?
Can I see the whole loop. I
Wow... I just re-read what I wrote. I sounded like a jerk didn't I.
Sorry about that didn't mean it that way.
-Original Message-----
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Wednesday, October 21, 2009 11:15 AM
To: cf-talk
Subject: RE: Checking line 26 or 27
I think the logic i
I think the logic is a little off.
You only need either line 26 or line 27.
That will set invoice number to the value in either 26 or 27 (I assumed
this was in a loop).
Having a bigger section of code would have helped more. Also, there is
probably a cleaner way to do t
imagesW200 is a query result. I believe you have to use imagesW200.name
to reference the actual name.
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Tuesday, October 20, 2009 2:03 PM
To: cf-talk
Subject: Ok...I give...what's wrong with this code?
I'm g
#chr(252)#
Don't know how it will display if the computer doesn't have the
wingdings font though.
Steve
-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk]
Sent: Friday, October 16, 2009 1:47 PM
To: cf-talk
Subject: Re: display wingding character code
is there no way
ore readable than NOT len(),
but the result is the same.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/10/15 DURETTE, STEVEN J (ATTASIAIT) :
>
> You can only pass in things that resolve to true/false, zero/one,
> yes/no, etc.
>
> Using not
AM
To: cf-talk
Subject: RE: cfprocparam - null setting
Can you pass anything other than true/false to the null parameter in
cfprocparam?
I know you can in cfqueryparam, but I was under the impression than in
cfprocparam it's strictly true/false
-Original Message-
From: DURETTE, STE
put TRUE in the NULL and pass a null to the procedure.
I do this all the time to ensure that the proper values get to my
procedures.
Steve
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Thursday, October 15, 2009 8:59 AM
To: cf-talk
Subject: RE: cfprocparam - null setting
Actually, I think you can solve this problem easily. If the only two
bad options are zero and "" then try this...
Of course replace Variables.myPassIn with whatever your variable is.
Steve
-Original Message-
From: Kris Jones [mailto:kris.jon...@verizon.net]
Sent: Thurs
101 - 200 of 242 matches
Mail list logo