use:

like 'c%'




                                                                                       
                            
                    "Matt Horn"                                                        
                            
                    <[EMAIL PROTECTED]        To:     <[EMAIL PROTECTED]>              
                       
                    rn.org>              cc:                                           
                            
                                         Subject:     [ cf-dev ] SQL                   
                            
                    07/07/2004                                                         
                            
                    14:28                                                              
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    dev                                                                
                            
                                                                                       
                            
                                                                                       
                            



Hello again


any reason why Access returns one record for this query

Select ProductionHouseName, ProductionHouseID from tblproductionHouse
where productionhousename like 'c*'

but query.recordcount in CF returns 0 ?

Matt
|\--------------------/|
Matt Horn
Web Applications Developer
Ph:+2782 424 3751
W: http://www.matt-horn.org
E:[EMAIL PROTECTED]
|\--------------------/|




-- 
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
 
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
      *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
           *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]

Reply via email to