On Thu, 19 Jul 2001 21:05:56 -0700, Saro [EMAIL PROTECTED] wrote:
Did you read chapter 9 Debugging CFML Applications from Studio of
Using_coldfusion studio\ folder.
It explains step by step for debugging.
Of course I didn't! That would be far too obvious a place to look :)
Thanks.
Kay.
Everyone.net is who we used to usethey are just getting terrible with
the number of obtrusive ads, pop unders and the like...just need some CF
solution.
Eric J Hoffman
Director of Internet Development
Small Dog Design, LLC
www.smalldogdesign.com
-Original Message-
From: Eric
The mail server in question is hosted by an ISPso not sure...
Eric J Hoffman
Director of Internet Development
Small Dog Design, LLC
www.smalldogdesign.com
-Original Message-
From: John Fix 3rd [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 5:14 PM
To: CF-Talk
Subject: RE:
OT: I'm hoping someone who knows more about systems than I do can help me
...
I'm getting spam coming into my email account at the rate of 10-20 a
minute for 20 hours now. The messages are all identical, including the
time and headers. Every time I collect my email from that server, there
are
Try using my custom tag
CF_WebWizard
You will find it at cfxtras.com
Regards
Hamid Hossain
--- Dylan Bromby [EMAIL PROTECTED] wrote:
specifically, use:
Pagename=#URLEncodedFormat('Rosemarie Rossetti,
Ph.D. - Inspirational
Speaker')#
using the single quotes inside the function
I'm using cfset cfusion_dbconnections_flush() to unlock
a database.
Access 2000, NT4.
The function does successfully delete the .ldb file
and the .mdb file can then be re-opened OK.
But afterwards, when I open the .mdb file using Access itself,
on exiting Access I get an error message
There
Wow! I thought it was supposed to equal the size of all the
templates, not be four times bigger. Where did you get the 4X?
Is that something empirically derived?
OK, the reason that I said 4x and the article says 10x is that it doesn't
store the actual CF template in cache, but the P-Code
right click on the globe thingy
select delete project
That seems to have done it, recreating the project sorted it :-)
By the way, this took me a while to figure out.
I'd never spend my own mony on Studio...
~~
Structure your ColdFusion code
Chris, thanks
KOla
-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 16:28
To: CF-Talk
Subject: Re: cf administrator settings
-- Original Message --
from: Kola Oyedeji [EMAIL PROTECTED]
Hi does anyone have a
Philip
Any particular reason why the template cache should be 4 times the total
size of all your
templates?
ps. you seem to always win something at all the meetings! ;-)
KOla
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 17:28
To: CF-Talk
I agree Bill, that a test would be a real turn off to me, if I was applying
for a position.
I would be more interested in the sort of person they are, if they would fit
in to the team (back to the beatles or stones question i guess), their
*understanding* of the work we do, their attitude
Agree with you Peter about CF studio 5. I have used it for 2-3 weeks, no
crashes, no major probs at all.
I am a BIG fan of Studio, and am pleased that it seems to be going the right
way.
Will
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 05:47
There is a presentation on the figleaf site:
http://www.figleaf.com/figleafhome/cfug/figpubs.htm
I still havent sussed it out though!
HTH
KOla
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: 20 July 2001 04:57
To: CF-Talk
Subject: CF Studio debugger tutorials?
Bill,
We had 3 servers with the patch installed and it did not fix the
problem. We had to manually remove the .ida and .idq mappings and it has
been fine since.
There were a few others on our local CF users group list that had to
manually remove them as well.
Tim P.
- Original Message
Hi does any one have a good strategy or can recommend some tools/resources
on backing up:
The backing up system here is really sloppy and we'd like to formulate some
system of backing up all of the following:
win2k configuration,
IIS 5 settings,
SQL server database and data,
coldfusion
For the last day I have been getting emails into my mailbox continuously
round the clock - at the rate of 10-20 a minute. I am trying to work out
why it's happening. Can anyone give me any hints?
It's a plain commercial message - earn $15000 a month working at home doing
no work at all kind
On 7/19/01, Parra, Fernando penned:
will I be able to have several webservers on the same server using the
Professional Cold Fusion Server or do I need the Enterprise
edition?--example:
sub1.domain.edu
sub2.domain.edu
These 2 subdomains will be completely different websites.
I presume you
For the last day I have been getting emails into my mailbox continuously
round the clock - at the rate of 10-20 a minute. I am trying to work out
why it's happening.
car to share with us how far have you got ?
Can anyone give me any hints?
you're being abused?
It's a plain commercial
-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]]
Subject: RE: SPAM - Why is he doing this to me?
For the last day I have been getting emails into my mailbox continuously
round the clock - at the rate of 10-20 a minute. I am trying to work out
why it's happening.
car
With ColdFusion Server 5 now in the hands of developers, we're excited to
hear your feedback and learn about your success. How has the increased
developer productivity, simplified management, and enhanced performance of
ColdFusion 5 helped you with your projects?
Tell us about the new
I have data in my database that has # signs around some text, i.e.,
#something#, etc.
When I try to output the data, it's not printing. Anyone know how to get
this to display?
TIA,
Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: [EMAIL PROTECTED] or
[EMAIL PROTECTED], or
I need to clarify that the records from the database are being output
randomly, so I never know when the record with the # signs in it is going to
display.
TIA,
Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: [EMAIL PROTECTED] or
[EMAIL PROTECTED], or
[EMAIL PROTECTED]
ICQ:
You will need to replace # with ## with the Replace() or the REReplace().
HTH
-- Original Message --
from: Yvette Ingram [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 20 Jul 2001 09:03:30 -0400
I have data in my database that has # signs
I usually read every domain name on a post of the sort and send an abuse
email (abuse@domain) to try and stop it. In many cases the domain is a spam
domain and I'll block it from the HoF mail server. If you investigate and
see that they are a spam server then you can do the same. This or course
I own the email account. I change my password. You can't relay through the
account or at least I tried that and tested and it bounced. So I don't see
what he's got to gain by sending me a gazillion emails.
I can't do any of that - I'm not the systems admin. If I was, I could just
shut his
I think it applies to both, but we're running CF 5.
tom
Brian Hogue [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
tom -
Is this CF 4.5 or CF 5? Thanks in advance.
-brian
~~
Structure your ColdFusion code with Fusebox. Get
Return-path: [EMAIL PROTECTED]
He's using an unsecured mailing list server to spam from. Are you a
member of the bgrass-l mailing list served from the University of
Kentucky? (I think uky.edu is Kentucky U).
If so: A - unsubscribe from the list, and B - Notify the list
administrator. You
cfoutput
#replacenocase(stringfromdatabase, #, ##, ALL)#/cfoutput
Hey Yvette. Hope things are going well, long time no talk!
Sandy
-Original Message-
From: Yvette Ingram [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 6:09 AM
To: CF-Talk
Subject: Re: Displaying # signs from
Hello!
I'm not understanding what the SET NOCOUNT statements do in SQL Server...
I'm using the @@IDENTITY variable to duplicate record id's between tables.
In Example 1, the SELECT @@IDENTITY statement does not work. In Example 2,
where the 1st query is inside a SET NOCOUNT block, the SELECT
Hey all!
I need some help with the CFX_CyberCash tag written by CyberCash themselves.
I installed it and started to modify my code to use the new inputs and
return fields but none of the return fields from the documentation are
there.
I'm using the Command-Style messages interface with an
Does anyone know of a java applet or tag that opens a pop up window that
gives a warning of: You have selected to clear this form - are you sure?
Then gives the choice of Yes or No. If yes is selected then the window
closes and form is cleared else if No is selected then window closes and
form
AH! Yes I am a member of that list. Perhaps that's what's caused it. I'll
write to them.
Thanks for the suggestion. To be honest I hadn't noticed that in the
headers.
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Jeff Beer [mailto:[EMAIL
An easy way to do this would be to utilize a Javascript alert box:
function ClearFunction()
{
if (alert(Are you sure you want to clear this form?))
document.form_name.reset()
}
...
...
input type=button value=Click here to clear form
OnClick=ClearFunction()
Disclaimer: Code is
Typically when you issue a command to MS-SQL, it tells you how many rows are
affected by the command. If you insert a row ... SQL will return the number
of rows affected. This should be one if only one row was inserted.
What happens with CFQuery is that it accepts the first recordset returned
I'm on the digest version of the list (a few too many emails for me to track
otherwise), so I get everyone's comments all at the same time. Because of
that, I'm not including any snippets from other messages -too many.
The new list for open source sounds great. I just signed up.
It's open
2. Does anyone have any ideas on how to decrypt the results of
CFX_PWCARDCRYPT on a Unix box?
cfx_pwcardrypt uses the standard RSA algorithm, and can
create/encrypt/decrypt 512, 1024 and 2048 bit keys. In
theory, if there was
a tool on *nix to decrypt standard RSA and you used
the same
This header does not look complete to me. Is 216.9.67.204 your system? If
not then where is the Received: line for your system. You need to go ARIN
(http://www.arin.net) and lookup The IP addresses in the header, not the
domain names (which can be easily spoofed). The most-likely-to-be-real
To my knowledge, as long as both tables are in the same database, using
cftransaction action=rollback
isolation=serializable(queries...)/cftransaction effectively creates
the lock you are looking for (equivalent to an exclusive lock but for a
database). By default the isolation attribute is
If you can use one of the following:
SQL7 @@identity
SYBASE @@identity -- I think
Oracle sequence_name.curr_val
these have to be identity fields for SQL and SYBASE and sequences for
Oracle. Identity fileds and sequences are essentially the same as
autoincrement. I have only seen autoincrement in
Hi all,
I am considering implementing the fusebox methadology
on all my new projects but wanted to throw something
out to all of you and get your feedback. I have heard
that on heavily trafficked sites that all of the
cfswitch's bog down the apps performance. I have
also heard some possible
cfinclude template=#attributes.fuseaction#.cfm
Will this work even if I'm using attributes.XFB.fuseaction?
Well, no, because attributes.fuseaction will be undefined.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Sandy:
Thanks. Now that was simple. I'm brain dead. Good to hear from you. Hope
things are going well for you too in this crazy market.
Thanks again,
Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: [EMAIL PROTECTED] or
[EMAIL PROTECTED], or
[EMAIL PROTECTED]
ICQ:
i think he's assuming that attributes.fuseaction has already been defined.
which is a good point for the question.. you can use any variable schema
you want as long as it contains the proper data and exists.
On Fri, 20 Jul 2001, Thomas Chiverton wrote:
cfinclude
Weird shot in the dark sort of question for anyone bored who may have an
answer:
Does anyone know what the email throughput rates are for cfmail running with
a mail server (post.office) on another machine? We notice something like 1
email per second shortly after a reboot, it then slows
OK, We're about to take the plunge with our first managed, dedicated server
solution. Edge Web Hosting is who we're almost ready to go with. If
anybody has had experience with them, good or bad, would you be so kind as
to contact me off list with your comments?
Thanks,
Dave
I have heard that on heavily trafficked sites that
all of the cfswitch's bog down the apps performance.
A question and a suggestion:
Have you heard this from folks who actively (and competently) use Fusebox or
from folks that don't actually know what they're talking about? It's amazing
how
Does anyone know what the email throughput rates are for
cfmail running with
a mail server (post.office) on another machine?
Should be huge - remember how this list runs :-)
We notice
something like 1
email per second shortly after a reboot, it then slows
gradually until the
nest
It was one of my friends at duodesign and i do believe
they are fairly competent.
Thanks for the suggestions.
~jason
-- Original Message --
from: Ken Wilson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 20 Jul 2001 11:23:39 -0400
I have
It is funny this came up as i posted a question today to the fusebox list
regarding the performance of fusebox here are 2 responses:(hopefully they
dont mind me reposting them here)
---
This is a very grey area, where I think you'll find
Fusebox wins
Among other things, I have a mailing list of 49,000 subscribers. Some are
now complaining they are getting multiple copies of the e-mail that goes
out. They are not duplicated in the database. I also have a feedback form on
one site that is also kicking multiple copies of one email out.
Has
I would take one recipient to troubleshoot and then look in the mail server logs. I
would look to see how many times the mail
server received the mail from the cf server and then how many times the mail server
sent mail to the recipient. Since CFMAIL does
not send mail directly then it could
I am considering implementing the fusebox methadology
on all my new projects but wanted to throw something
out to all of you and get your feedback. I have heard
that on heavily trafficked sites that all of the
cfswitch's bog down the apps performance. I have
also heard some possible
Jason,
In a long running thread on the cf forums, a couple of users attributed
cfswitch to eventually hanging the server. However they were looping over
the cfswitch a few thousand times, so I find that suspect.
I had read on Forta's site that cfswitch is faster than using a lot of
To my knowledge, as long as both tables are in the same
database, using cftransaction action=rollback
isolation=serializable(queries...)/cftransaction
effectively creates the lock you are looking for (equivalent
to an exclusive lock but for a database). By default the
isolation
=
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
Is there a way to access the groupwise address book from the cold fusion server? Need
some insight.
Thanks.
We are running CF 4.5 sp2 and NT 4
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I had some trouble with this tag until I added 'version=2.1' as a
parameter. Then it worked fine. Sorry I don't have a good address either,
and the documentation seems to be rather worthless.
When trying to get it to work, I found debugging to be helpful:
DEBUG_LEVEL=10
Help
What am I doing wrong here? I get a just in time compilation
error.
CFQUERY name=qname
UPDATE tbltable
SET tblfield =
'#PreserveSingleQuotes(Trim(EVALUATE(#columnname#_#recordnumber#)))#'
/CFQUERY
its erring on the ( before EVALUATE.
if I take
Have you tried evaluating the value outside of the PSQ function...
CFSET myVarWithQuotes = Trim(EVALUATE(#columnname#_#recordnumber#))
CFQUERY name=qname
UPDATE tbltable
SET tblfield = '#PreserveSingleQuotes(myVarWithQuotes)#'
/CFQUERY
-Original Message-
From: Bruce,
ok guys, please tell me if there is a better way of doing this.
basically i have 2 tables, the second one having a many to many
relationship. What I am trying to do is insert a record into the first
table, then use the id (it's an identity field) of that row to insert into
the second table
Yes I did that, but was wondering if my original statement was formatted
wrong or just not possible.
why do something in two steps if its possible in one.
-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 10:30 AM
To: CF-Talk
Subject:
try this type of code, just copied it straight from one of our projects
CFQUERY NAME=Insert DATASOURCE=#Application.datasource#
SET NOCOUNT ON
INSERT
INTO dbo.T_User
VALUES (
'#CompanySiteID#',
'#form.last_name#',
'#form.first_name#',
'#form.misc_num#',
Sandy:
I think that what I thought was my problem is not the problem.
In the database I have coldfusion code, i.e., cfset #thisdate# =
#DateFormat(Now())#.
I'm trying to display this code, but I don't think the # signs are not the
problem. I think it's the cf code itself. Because I have text
I also was about to put a question like this out here... I am grabing two
queries..using the results of one query as a display for the other..
cfoutput query=Get_items
cfoutput query=Get_fields
td#Get_items.#Get_fields.Iadmin_name#/td
So I need help as well
Thanks
Brian
As an added note, when assigning values to variables, the # signs are not
needed at all:
cfset thisdate = DateFormat(Now())
I think that what I thought was my problem is not the problem.
In the database I have coldfusion code, i.e., cfset #thisdate# =
#DateFormat(Now())#.
I'm trying to
Here's what I use for a parent child relationship, both have an Identity PK:
DECLARE @Ident Int
DECLARE @AdItemIdent Int
SET NOCOUNT ON
INSERT INTO AdSummary
(
CreateDateTime,
CustomerID
)
VALUES
(
Scratch that...I really dont want to make database calls that many times. I
will just use an array for this. But I am still interested in how you can put
two CF variables together like this..
Brian
-Original Message-
From: Yager, Brian T Contractor/NCCIM
[mailto:[EMAIL PROTECTED]]
Tony:
Yes I know. I was trying to demonstrate an example of my problem with
cfcode and pounds signs in my database table. Probably should have used
another example.
Thanks just the same.
Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: [EMAIL PROTECTED] or
[EMAIL
Hello Brian,
if memory serves me correctly you cannot nest outputs.you can however nest loops
so a
query loop would sort you
--
Critter, MMCP
Certified ColdFusion Developer
TerraVerge
Geotechnologies
http://terraverge.com
---
Friday, July
Here's how:
#Evaluate(Get_items. Get_fields.Iadmin_name)#
Kevin
[EMAIL PROTECTED] 07/20/01 11:02AM
Scratch that...I really dont want to make database calls that many times. I
will just use an array for this. But I am still interested in how you can put
two CF variables together like
If the session var is not an array:
cfloop from=1 to=10 index=i
cfset somevar = somevar session.var i
/cfloop
If it is an array
cfloop from=1 to=10 index=i
cfset somevar = somevar session.var[i]
/cfloop
-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
hi all, it's me again, hehehe :). well, i've come across many moments where
i wonder whether i should use an ID, or the actual information. here's an
example. I have two tables, one called STATELIST, and one called Friends.
The statelist table contains the state abbreviations along with an
exactly what i needed!! thanx!!!
From: Dunwiddie, Bruce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Inserting Records
Date: Fri, 20 Jul 2001 12:45:49 -0500
try this type of code, just copied it straight from one of our projects
CFQUERY NAME=Insert
Hi all,
I have a form with a text area field where users can text, which in turn
gets inserted in the DB. It all works good till the user enters commas and
quotes.
example:
textarea name=message
This is user input. The user likes to use commas and quotes, like this.
The user said, I just
Use the '#preservesinglequotes(message)#' function to preserve the single
quotes in the text.
John Anderson
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 11:58 AM
To: CF-Talk
Subject: He said, I would like to insert commas and quotes in the
I would use the two digit state code as the primary key field on the state
table, and store it in the state field in the friends table. No point in
using an aribitrary number for the id in a table where you already have
short unique identifier.
At 01:25 PM 7/20/01 -0500, you wrote:
hi all,
A dump of the PriSched table reveals that STime and ETime look like such:
1899-12-30 06:00:00 1899-12-30 07:00:00
1899-12-30 07:00:00 1899-12-30 11:00:00
So, what does the following query not work?
SELECT STime, ETime, Name, Describe FROM PriSched WHERE ((NOT
If a state secedes then we will have more to worry about than whether or not
to use a code table for states.
To answer your question a code table is good for other reasons. One being
you could then use those values elsewhere in the same application and you
don't have to duplicate data.
1. Don't ever delete states- even if FL breaks off and floats away to become
part of South America you will usually need that information for historical
reasons! (I heard a story recently of a school that dumped all of their old
courses out of the database- but it didn't dawn on them that they
Any yous guys know how to do dis?:
SELECT FirstName, LastName
FROM Names
WHERE LCase(FirstName) LIKE LCase(#Criteria#)
...meaning whether they search for bob or Bob I want to return
Bob.
But this doesn't work... Error code says 'invalid column name'
Sos I thought maybe:
SELECT
I had posted this in a few days ago to the list, but here goes again :)
Hope it helps
Put this above your query somewhere
!--- initialize the variable - bad_chars ---
cfparam name=bad_chars default=
!--- initialize the variable - good_chars ---
cfparam name=good_chars default=
!---
I have a form with a text area field where users can text, which in turn
gets inserted in the DB. It all works good till the user enters
commas and quotes.
Note, I'm coming from a SQL Server 7 point of view - the top option works
fine in that, but I can't guarantee other engines
OK, there
am i missing something?? isn't there something inherently wrong with using
a state abbrv. as a primary key? as an index ok but primary key?
uniqueness?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
What are some of the tools or methods to use when trying to
debug Fusebox apps?
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
no!!! u guys dont understand. the state thing was an example! it was
a design issue in general, and i wanted a general answer. when is it good
to use and id, and when is it good not to. it's good to use an id if the
information changes a lot, but it could be sitll linked by ID, and
htmldiv style='background-color:'DIV
PNevermind. I found the answer./P
PThe script does not display if there is only one item in the database (and throws
an error if there are none). I'll have to see if I can tweak the script to account for
these scenarios.BRBRBR/P
DIV/DIV
PSTRONGFONT
One way to solve this problem is this:
Have a reference table States with the abbreviations etc.
Have your Friends table but have the state field be a text field. Thus, the
state abbreviations will be inserted into the Friends table as text ie 'WA'
Washington secedes, your Friends table will
debugging fusebox??? man, they use so many modules u dunno where stuff is
ocmin from heh
From: Stephen Hait [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Debugging Fusebox apps
Date: Fri, 20 Jul 2001 15:26:02 -0500
What are some of the tools or methods
Dear CF'ers,
I created a frames based directory,
http://medsearch.medmatrix.com/explore/category2website.htm that has a
problem with the main or bottom right window. Some sites are very
unruly and are not confined within the MAIN window - they break out and
take up the entire screen. Very
only having one ref table can be messy in and of itself. It is not clear
what is in it and if you don't need some of the data you have to clean up.
Where as if you have multiple code/ref tables they will be organized in a
coherent manner, hopefully, so that if for what ever reason, all the states
Should be fine double quotes should not affect the insert of the data.
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 12:45 PM
To: CF-Talk
Subject: RE: He said, I would like to insert commas and quotes in the
DB
What if they double quotes?
An Editor with multi-file search capability
A printer...
Seriously, when you have logic distributed among many modules a
printer helps to flip between modules
HTH
Dick
At 3:26 PM -0500 7/20/01, Stephen Hait wrote:
What are some of the tools or methods to use when trying to
debug Fusebox
Nice, Ill try this thanks
j
-Original Message-
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 12:11 PM
To: CF-Talk
Subject: Re: He said, I would like to insert commas and quotes in the
DB
I had posted this in a few days ago to the list, but here goes again
cfoutputcfset #thisdate# = #DateFormat(Now())#/cfoutput
Casey Cook
Yvette Ingram [EMAIL PROTECTED] on 07/20/2001 01:03:38 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: Re: Displaying # signs from database
Tony:
Yes I know. I was trying to
Or (replace(evaluate(message),','',ALL)
And like John says, double quotes should not affect the input of the
database. May not need the evaluate.
Casey Cook
John Anderson [EMAIL PROTECTED] on 07/20/2001 02:53:57 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
I just did this a week ago with the help of somebody on this board + some
extra code.
1. Create a custom tag - sql_chars.cfm
start sql_chars.cfm --
!--- initialize the variable - bad_chars ---
cfparam name=bad_chars default=
!--- initialize the variable -
I know there is no PWS for Win2000 Pro but what do I use to locally host
sites using CF single user server on a laptop for demos and development off
the lan?
Where/how do I set this up?
Can anybody point me to the correct resource so I can find out how to add
this service?
Thanks a lot!
Justin
Comparing dates is a pain in the *%% as I'm sure you've found. Try
formatting the dates as ODBCDateTimeFormat() inside the SQL statement.
If you can't set the date with that function, the database isn't going to
read it correctly either.
---mark
=
Mark
You want to use an id/reference table anytime the information is the same
repeated multiple times in your database. I've used them for
occupations/jobsites/teachers/salesperson/team names/School names/Company
names/Doctors list/etc. Generally they will be used when:
a. info that generally
if you create a global error page when something goes wrong and give your
users a friendly message that they can not go back anymore that would work.
so everytime a specific variable comes up empty that isn't supposed to,
display a message according to what the variable is.
-Original
1 - 100 of 149 matches
Mail list logo