This will work.  But why not do them in smaller blocks of records.  Why not
set a Counter on the page and send it in the URL back to the page, thereby
looping over the entire page until finished.  And limit the number of
records coming out of the query.

Vance Duke
Cold Fusion Application Developer
i2 Technologies
(469) 357-4729



                                                                                       
                                  
                    "Larry Juncker"                                                    
                                  
                    <larry@HeartlandInt        To:     "Cf-Talk@HouseofFusion. com 
\(E-mail\)"                           
                    ernet.com>                 <[EMAIL PROTECTED]>             
                                  
                                               cc:                                     
                                  
                    09/15/00 11:54 AM          Subject:     OT: Removing CHR$(10) and 
CHR#(13) from an Access table      
                    Please respond to                                                  
                                  
                    cf-talk                                                            
                                  
                                                                                       
                                  
                                                                                       
                                  



APOLOGIES UPFRONT

I am in dire need of knowing how to remove the CHR$(10) and 13 codes from
columns in Access.

I have tried a simple COQUETRY and update but I keep crashing CF Server due
to my table having 60k records.

ANY HELP would be GREATLY APPRECIATED.

Larry Juncker
Senior Cold Fusion Programmer
Heartland Internet

------------------------------------------------------------------------------

Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to