How to change a text look in a message?
ColdFusion
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > ColdFusionGo to page: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next »

  Recent blog posts: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:
Wednesday, 17 December 2008
500 null James Smith 11:06:43
 Every now and again, often on pages that take a while to execute but not
always I receive a "500 null" in big black letters. The code looks like
this.

<head><title>JRun Servlet Error</title></head­><h1>500 null</h1><body>
</body>

Does anyone know what is causing it and how to avoid it as it is becoming a
real problem for us.

--
Jay



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=67

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:199083
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 11 answers | Add comment
Wednesday, 5 November 2008
cfhttp method="PUT" Rick Root 08:54:09
 Has anyone used this? I'm looking for an example of how to use CFHTTP's
PUT method. There are none in the documentation on livedocs.

Basically, we've been asked to upload a file on an automated basis, and
the vendor was kind enough to write us a vb script that does it, but I'd
rather use CF =)

Thanks.

Rick


~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=49

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:218860
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

Add comment
Friday, 17 October 2008
RE: TinyMCE Ewok 20:07:36
 Change the font-size in the css file you are using (default, advanced or
simple) for the body style.

For example, in default/editor_cont­ent.css under the body style, change
font-size:10px; to something higher... font-size:13px;



-----Original Message-----
From: Ian Skinner [mailto:ian.skinner-2wSdTXsJYQTBCgU9O1rxug@public.gmane.org]
Sent: Wednesday, October 27, 2004 10:40 AM
To: CF-Talk
Subject: OT: TinyMCE

At the recommendation of a recent posting to this list, I have been giving
the TinyMCE JavaScript WYSIWYG editor a try. I like how simple it is to
integrate into a web form and its functionality seems to be good. But,
using the default configuration the text is tiny in the web control to which
the editor is applied. But I can not find the proper setting to configure
this.

Can anybody who is using TinyMCE let me know which one I need to be using?

I posted this question to the TinyMCE list, but have not received a reply.
In fact, since I've subscribed to the list late last week, I have not
received a single message from it other then my question. It does not seem
to be very active.


--------------
Ian Skinner
Web Programmer
BloodSource
<file:///C:\Documen­ts%20and%20Settings\­iskinner\Application­%20Data\Microsoft
\Signatures\www.Blo­odSource.org> www.BloodSource.org­
<http://www.BloodSo­urce.orgSacramento>
Sacramento, CA

"C code. C code run. Run code run. Please!"
- Cynthia Dunning


Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.






~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=44

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:182722
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 15 answers | Add comment
Wednesday, 24 September 2008
Test....test... Quiet today... Yves Arsenault 03:54:16
 Hello...

Testing..

--
Yves Arsenault

"This year, or this month, or, more likely, this very day, we have
failed to practise ourselves the kind of behaviour we expect from
other people."
C.S. Lewis

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=48

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:175614
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

Add comment
Browser Session spawn G C 03:54:11
 Application:
An application where you can administer a number of companies and their users.

The issues:
You login to Company1 and click on User1 opening a different window. Now you need to open User2 from Company2. So in the Company1 browser you go to Company2 while leaving User1 window open. Now you open up User2 with its own set of session variables.

So you now have:
Original window has Company2 session variables.
AND
User1 window has its own session variables
AND
User2 window has its own session variables.

Should I not be able to use any one of those windows sessions independently of each other? User1 window is of course trying to use User2 session variables. And we cant have User1 accessing any of User2's session variables.

Can someone let me know how I can get CF server to dole out another session to a spawned window that will allow 2 even 3 sessions on the same box. Is this at all possible?

Thanks in advance,

GCruz


~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhostin­g.net

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:185544
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 1 answer | Add comment
April Fool's Erika L Walker-Arnold 03:54:10
 http://en.wikipedia.­org/wiki/April_1%2C_­2005


Cheers,
Erika



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=48

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:152534
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

Add comment
RE: IIS Append to the Request Header Steve Brownlee 03:54:09
 No, IIS only appends headers from the Web server to the browser, not the
other way around.

-----Original Message-----
From: Adrocknaphobia [mailto:adrocknaphobia-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Wednesday, February 23, 2005 12:01 PM
To: CF-Talk
Subject: SOT: IIS Append to the Request Header

Here is a pretty random question...

Can IIS append to the request header before it passes it off the CF?

-Adam



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=67

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:196159
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 1 answer | Add comment
Advanced Development Techniques in CFML Monique Boea 03:54:08
 

Friday, May 21 - 9:00 am


Speaker:Team Macromedia member Simon Horwith

In this presentation, advanced CFML techniques will be discussed. Topics
include CFSCRIPT, XML, and advanced techniques with ColdFusion Components
and Custom Tags.

<http://macromedia.­breezecentral.com/r2­3279712/>
http://macromedia.b­reezecentral.com/r23­279712/



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=40

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:113227
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
comment 1 answer | Add comment
List/Clean Application variables/objects Olivier Olivier 03:54:07
 Hello !

I am having some problems with I think are coming from a site using the Application scope to store variables and objects...

I was wondering if there is a way to list everything that is stored into the Application scope, so that I can run some CFDUMP on these and analyze what is going on....

Also, is there another way -besides restarting CFMX- to clear the application scope ? I understand the consequences of clearing this scope while the server and various sites are running, but I'd like to know if this is possible using CF code or script...

Thanks a lot everyone !

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=37

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:173954
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
comment 4 answer | Add comment
iif in MSSQL Richard Meredith-Hardy 03:54:06
 dear all

is there a way of doing the following in a query to MSSQL like you can
to access?

SELECT field1, field2, iif(field1 = field2,'same','diff­erent') AS mynote
FROM mytable
WHERE etc

I appreciate it could be done in a SP or by analysing the output but in
this case it is easier not to...

thanks


--
Regards;

Richard Meredith-Hardy
-------------------­--------------------­--------------------­--
r[dot]mh[at]flymicro[dot]com
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=40

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:178943
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
comment 5 answers | Add comment
Web Services problem Will Tomlinson 03:54:05
 I'm learning about using Web Services and I'm getting an error that doesn't make sense. Maybe someone could shed some light on the problem?

I'm using a CFC to simply retrieve some zip codes from a db.

<cfcomponent>
<cffunction name="myFunction" access="remote" returntype="query">­
<cfset getzips ="">
<cfquery name="getzips" datasource="#DSN#" maxrows="20">
SELECT zipcode FROM tblzipcodes
</cfquery>
<cfreturn getzips>
</cffunction>
</cfcomponent>


Then I'm invoking it using this:

<cfinvoke webservice="http://­www.wtomlinson.com/q­ueryCFC.cfc?wsdl" method="myfunction"­
returnvariable="ret­urnedquery">
</cfinvoke>

<cfoutput query="returnedquer­y">#zipcode#<br></cf­output>


It seems to work fine if the invocation is on my server, but when I have someone to place it on their server to call my web service, there's an error:

http://gtcc-it.org/­web-service.cfm

Could not generate stub objects for web service invocation.
Name: http://www.wtomlins­on..com/queryCFC.cfc­?wsdl. WSDL: http://www.wtomlins­on..com/queryCFC.cfc­?wsdl. java.net.UnknownHos­tException: www.wtomlinson..com­: www.wtomlinson..com­ It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can&apos;t be retrieved or it is dynamically generated, it is likely that the target web service has programming errors.

I'm assuming the XML file CF is creating
is erroring? Does anyone have any ideas?

Thanks,
Will

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=34

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:182793
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 7 answers | Add comment
The Real Da Vinci Code Angel Stewart 03:54:04
 Who the hell *WAS* Da Vinci!??
It's incredible that this guy came up with these things in the time period he did.

"Is his mysterious three-wheeled cart a proto automobile? A remote-controlled robot? A rolling Renaissance computer? The quest to
rebuild Leonardo's "impossible machine."

It is uncanny!
http://tinyurl.com/­3n8uq

-Gel


~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhostin­g.net

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:135091
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 1 answer | Add comment
problem producing pie charts - help Nick Cabell 03:54:03
 I'm having a terrible time producing (mostly) pie charts for a client.
The cfchart tag produces "solid" pie slices that do not close up perfectly,
and worse the shape of the pie is not consistently round, varying in
its oblong shape depending on the query results.

The results need to be copied into word processing documents, I have to
support older browsers, and the images need to be copiable into a
variety of word processing documents.

Has anyone faced and solved these problems OR can you recommend
a (hopefully) not too expensive alternative that I could integrate
with CF to produce results from queries.

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=35

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:166468
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
comment 1 answer | Add comment
Floods, Tornados, Earthquake, what next? Kevin Graeme 03:54:02
 Last month we had floods from so much rain. Last week we had tornados
touch down in town. Last night I woke up to the house rumbling from an
earthquake. (4.5 in Illinois and I'm in Wisconsin.).

I'm really worried to find out what's next. I draw the line at it
raining feiry brimstone.

-Kevin

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=36

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:117750
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
comment 2 answer | Add comment
RE:Katie( UplinkEarth - good CF hosting company?) Angel Stewart 03:54:01
 Kaatieeee!! :)­

*waves madly*
What's happening :)­
How you been? And how are the islands?
You bored and longing for the bustle of the city yet? ^_^

-Gel


-----Original Message-----
From: Katie Howell [mailto:klhowell@yahoo.com]

<sneaking out of lurkdom>

Love 'em. Great customer service. Any trouble tickets answered within 18-24 hours. They always send an email on the holidays with
their holiday schedule..notify you way ahead of time of any maintenence etc. There are cheaper providers, but I think the money is
well worth the service.

oh..and...happy holidays to all from the Marshall Islands....a chilly 83 degrees here today...

</back to lurkdom>

Katie


~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhostin­g.net

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:138181
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 5 answers | Add comment
HL2 unlocking Bill Wheatley 03:54:00
 33% unlocked!!!

--

William Wheatley
Coldfusion Guru

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhostin­g.net

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:5:136070
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/5
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:5
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13124.11887.5
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 7 answers | Add comment
CF / Oracle Error... Greg Morphis 03:53:59
 I've got an upload utility I'm using to allow the client to upload a
txt file which could go into 1 of 33 different tables.. the reports
are structured so differently it's impossible to put them all into one
table.

After uploading the first document (304 rows), I try to upload another
this one has 294. It gets to about 190-200 rows before crapping out on
me.
Cold Fusion reports "maximum opened cursors exceeded".
I did some research and checked with our DBA.. Our cursor limit is set at 1500.

I've looked over my code and cant see an issue with it.
I uploaded 2 documents each with 1 row without a problem.
I've uploaded 1 document with 800+ rows without a problem.

It only occurs when it's documents around 300 rows each.
Has anyone seen this before and can anyone suggest an idea.
I'd like to ask for an increase of the cursor limit as a last resort.


<code>

<cfset isProblem = "no">
<cftransaction action="begin">
<cftry>
<cfquery name="getSweepID" datasource="#applic­ation.config.getDSN(­)#">
SELECT seq_sweep_id.nextva­l AS id FROM DUAL
</cfquery>
<!--- insert main record --->
<cfquery name="sweepInsert" datasource="#applic­ation.config.getDSN(­)#">
INSERT INTO SWEEP_MAIN
(
SWEEP_ID, PHONE_ID, ACTIONUSER, ACTIONDATE, CATEGORY_ID
)
VALUES
(
<cfqueryparam value="#getSweepId.­id#" cfsqltype="cf_sql_n­umeric">,
<cfqueryparam value="#form.phonei­d#" cfsqltype="cf_sql_n­umeric">,
<cfqueryparam value="#session.use­r.emplid#" cfsqltype="cf_sql_v­archar">,
sysdate,
<cfqueryparam value="#form.catego­ry_id#" cfsqltype="cf_sql_n­umeric">
)
</cfquery>
<!--- get table name --->
<cfquery name="getTable" datasource="#applic­ation.config.getDSN(­)#">
SELECT sweep_table AS tbl_name FROM CATEGORY_SWEEP
WHERE category_id = <cfqueryparam value="#form.catego­ry_id#"
cfsqltype="cf_sql_n­umeric">
</cfquery>
<!--- get table columns --->
<cfquery name="getCols" datasource="#applic­ation.config.getDSN(­)#">
SELECT collate(t.column_na­me) as columns
FROM all_tab_columns t
WHERE t.table_name= '#getTable.tbl_name­#'
ORDER BY column_id
</cfquery>
<!--- loop over record and insert into table --->
<cfset strLen = ListLen(getCols.col­umns,',')>
<cfset counter = 1>
<cfoutput>Please Wait Loading...<br/></cf­output>
<cffile action="read"
file="#cffile.serve­rDirectory#\#cffile.­serverFile#"
variable="fileData"­>
<cfloop index="record" list="#fileData#" delimiters="#chr(10­)##chr(13)#">
<cfif counter gt 1>
<cfquery name="qryInsert" datasource="#applic­ation.config.getDSN(­)#">
INSERT INTO #getTable.tbl_name#­ (#getCols.columns#)­
VALUES
(
<cfqueryparam value="#getSweepId.­id#" cfsqltype="cf_sql_n­umeric">,
<cfloop from="1" to="#strLen-2#" index="i">
<cfoutput>'#replace­(evaluate("listgetat­(record,#i#,chr(9))"­),'"','',"all")#'</c­foutput>,
</cfloop>
'#evaluate("listget­at(record,#strLen-1#­,chr(9))")#'
)
</cfquery>

</cfif>
<cfset counter = counter + 1>
</cfloop>


<CFCATCH type="Any">
<cfoutput>
<h3>Oops, There's been an error</h3>
Please try again, if the problem persists <br/>
notify the administrator<br/>
Message :#CFCATCH.message#<­p>
Type :#CFCATCH.type#<p>
<cfset isProblem = "yes">
<p<i>Rolling back the attempted transaction</i></p>­
<cftransaction action="ROLLBACK" />
<cfquery name="delFile" datasource="#applic­ation.config.getDSN(­)#">
DELETE FROM DOCUMENTS WHERE DOCID = <cfqueryparam
cfsqltype="cf_sql_n­umeric" value="#docid#">
</cfquery>
</cfoutput>
</CFCATCH>
</cftry>
<cfif isproblem eq "no">
<cftransaction action="COMMIT" />
<script language="Javascrip­t">
<!--
alert("Finished: <cfoutput>#counter-­2#</cfoutput> rows added");
location.href="../u­pload/"
-->
</script>
</cfif>
</cftransaction>
</cfif>



</code>

--
Auxilium meum a Domino

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhostin­g.net

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:183909
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 1 answer | Add comment
OT: ADD System? Ray Champagne 03:53:58
 Has anyone here (maybe in a past life?) worked with this system? It is a
very common program used by Oil/Propane/Natural­ Gas/etc delivery companies
to track their customers, schedule deliveries, set prices, just about
everything needed.

We are working with a company that uses it, and we need to get some info
out of the DB, but can't figure out how. Eventually, we would like to get
the whole customer info out of the Db so that customers can check their
next delivery date, pay bills, etc, but for right now we'd be happy just
being able to export out some of the info in a usable format.

Problem is, the ADD company has a web module that is ridiculous in price,
so they will not help us try to 'beat the system' by developing our own. I
know what we need to do, just don't know how to do it.

So, anyone? anyone? Bueller?

Longshot, I know, but this list surprises me sometimes....

Ray

===================­====================­======
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.o­rg
===================­====================­======

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=11

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:175884
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
Add comment
ANNOUNCE: Hal Helms Fusebox and Mach-II classes @MAX 11/1, 11/5/04 Michael Smith 03:53:57
 Interested in Fusebox 4 and Mach-II? Want to learn
from one of the creators of these frameworks?
Come to a Hal Helms full day class before or after
MAX on "Intro to Fusebox 4.1 and FLiP" and "Intro to OO and Mach-II"
The classes are in New Orleans before and after MAX. Plus Hal,
Simon Horwith, Shlomy Gantz and more are speaking at CF_Underground VI
in New Orleans before MAX. Attendees will get an exclusive
CF_shot glass. See below for details.

- Michael
PS Ben Forta is planning on come to speak at CF_Underground VI
panel before MAX

Conference and training news
*******************­*********
* CF_Underground is Sun 10/31/04 For photo of CF_shot glass see
http://www.cfconf.o­rg/cf_underground6/
* FB103 Hal Helms Introduction to Fusebox 4.1 and FLiP class MAX New Orleans Mon
11/1/05
* MT101 Hal Helms Intro OO and Mach-II class MAX/New Orleans Fri 11/5/05

* FB103 Hal Helms Introduction to Fusebox 4.1 and FLiP
*******************­********************­***************
Before MAX New Orleans Mon 11/1/05
Full Day $349

Fusebox is a framework for writing web applications created by Hal Helms and
John Quarto-vonTivadar. Fusebox is, by far, the most widely used framework among
ColdFusion developers.

In this one-day class, Hal Helms introduces the key concepts of Fusebox and the
Fusebox Lifecycle Process (FLiP) and explains how to use the new features of the
language to create better applications. In addition, Hal explains how FLiP can
be used to create predictable project successes and share case stories of large
and small projects that have succeeded using Fusebox and FLiP. More info at:

http://www.teratech­.com/training/fb_cla­sses.cfm#fb103

* MT101 Hal Helms Intro OO and Mach-II
*******************­*******************
After MAX/New Orleans Fri 11/5/05
Full Day $349

Mach-II is an object-oriented framework for writing web applications created by
Ben Edwards and Hal Helms. The goal for the framework is to provide assistance
to ColdFusion developers who want to write Model-View-Controll­er applications
using best OO practices. Macromedia uses Mach-II internally for many of its own
applications.

In this one-day class, Hal Helms provides an extensive primer on object
orientation and explains how CFCs do—and do not—properly implement OO essentials
and introduces Mach-II as a powerful framework that helps developers leverage
the benefits of object orientation.

Registration http://www.teratech­.com/training/oc_cla­sses.cfm#mach_ii



--
Michael Smith, TeraTech Inc - Tools for Programmers(tm)
TeraTech voted Best Consulting Service by CFDJ readers!
CF/ASP Web, VB, Math, Access programming tools and consulting
405 E Gude Dr Ste 207, Rockville MD 20850 USA
Please check out http://www.teratech­.com/ - email mailto:info-gWXgX43­fwpxWk0Htik3J/w@publ­ic.gmane.org,
or call us for more information; in the USA at 1-800-447-9120,
+1-301-424-3903 International, Fax 301-762-8185



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=34

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:181962
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

Add comment
OT: JavaScript onSubmit Robert Orlini 03:53:56
 I have a JavaScript question. How can I combine these two validation scripts? I need it to do a return confirm and also a validation to make sure the proper field is selected. I'm trying to combine the onSubmit of "onsubmit="return checkUserInputs(thi­s);" and "onSubmit="return verify". SEE BELOW CODE

I'm weak with JavaScript.

Any suggestions please?

Thanks.

Robert O.

-------------------­--------------------­-------------------

<SCRIPT LANGUAGE=JAVASCRIPT­>
function verify(){
msg = "Submit Signoff sheet?";
//all we have to do is return the return value of the confirm() method
return confirm(msg);
}
</SCRIPT>
<form method="POST" action="action.cfm"­ name="searchQuery" onSubmit="return verify">



<SCRIPT LANGUAGE=JAVASCRIPT­>
function checkUserInputs(for­m)
{
// One of the trials must be selected.
if(form.name.option­s[0].selected)
{
alert("Please select a trial.");
return false;
}
}
</script>
<form action="action.cfm"­ method="post" onsubmit="return checkUserInputs(thi­s);">




~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=67

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:191868
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 2 answer | Add comment
Help with setting up DSN Kevin 03:53:55
 Hi everyone,



I need some serious help. I have installed Microsoft SQL Server but when I
try to setup the data source name in ColdFusion MX I get this error:

Not associated with a trusted SQL Server connection

I have searched the Microsoft Site and Google and have found nothing that
helps. Does anyone have this setup working on Windows XP Pro and IIS 5.0?

Thanks,

Kevin



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=36

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:175901
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
comment 7 answers | Add comment
Public service announcement Steve Brownlee 03:53:54
 For any of you J2EE folks out there, I thought I'd post my latest blog entry
about removing references to Flex during startup if you don't need it. I was
told it couldn't be done by he-who-must-not-be-­named, but it turns out it can
be done. Only reason I'm doing this is because I've seen this question come
up several times.

http://www.orbwave.­com/cfjboss/2005/03/­dont-flex-your-muscl­es.html

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=67

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:201016
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

Add comment
Named anchor Pascal Peters 03:53:53
 Is it possible to find a named anchor passed in the url (if there is
one) in ColdFusion?

Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM

~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=40

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:162696
Archives: http://www.houseoff­usion.com/lists.cfm/­link=t:4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
comment 2 answer | Add comment
Can we pitch in to send one of the goodguys to CFUNITED? Will The Game 03:53:52
 Hey all,

As you know, Jared R-H posts quite a bit here. He's helped me out a ton, and probably has helped many of you as well. He's an exceptional CF'er, JS'er, blogger and provides plenty of great code for us to use. As of right now Jared will not be able to attend CFUNITED do to some unfortunate personal events, so I'd like to ask everyone on the list if they could chip in to help him make it to CFU. I'm not going to be able to make it myself, but if I can chip in to help someone else go I will. And I can't think of anyone better than him for the trip!

If you feel the urge to help another CF'er get to CFU, maybe you can think about visiting his blog and making a small donation.

http://www.web-rele­vant.com/blogs/cfobj­ective/

I'll be donating $25 myself. If only 30 of us were to donate that amount, it'd go a long way to get him there.

Thanks much,
Will


~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=67

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:201437
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4

comment 1 answer | Add comment
OT: Massage wanted for CFUN conference attendees Michael Smith 03:53:51
 I am running the CFUN-04 conference http://www.cfconf.o­rg/cfun-04/ this
weekend 6/26 - 6/27 in Rockville MD and over 550 web computer
programmers are coming. It occurred to me that computer people often
have neck and shoulder aches and might be interested in getting a
massage at the event and that this would be a great opportunity for
someone who does body work to get new clients and earn some money too by
giving short massages at the event.

Or if you are interested in web programming too we could give you a free
pass to the event too in return for massaging the speakers. (CFUN costs
$299)

I imagine that a massage chair would be helpful but that for neck and
shoulder massage that a regular chair would work too. Contact
michael-gWXgX43fwpx­Wk0Htik3J/w@public.g­mane.org ASAP if you are interested. You will need to be
licenced to give massages in Maryland.

--
--
Winner in CFDJ awards Best Consulting

Michael Smith, TeraTech, Inc
405 E Gude Dr Ste 207, Rockville MD 20850
CF , VB, SQL, Math custom programming
Voice: +1-301-424-3903 x110, 800-447-9120 Fax:301-762-8185
Web: http://www.teratech­.com/sig/
Email: mailto:michael-gWXg­X43fwpxWk0Htik3J/w@p­ublic.gmane.org ICQ: 66057682



~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~~~~~~~~~~~­~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoff­usion.com/banners/vi­ew.cfm?bannerid=34

Message: http://www.houseoff­usion.com/lists.cfm/­link=i:4:167761
Archives: http://www.houseoff­usion.com/cf_lists/t­hreads.cfm/4
Subscription: http://www.houseoff­usion.com/lists.cfm/­link=s:4
Unsubscribe: http://www.houseoff­usion.com/cf_lists/u­nsubscribe.cfm?user=­13123.11886.4
Donations & Support: http://www.houseoff­usion.com/tiny.cfm/5­4
comment 1 answer | Add comment

Add new topic:

How:  Register )
 
Логин:   Пароль:   
Комментировать могут: Премодерация:
Topic: