RE: Database problems

[John Allred]

                                                                                       
             
                    Katrina                                                            
             
                    Chapman              To:     [EMAIL PROTECTED]             
             
                    <kchapman@vol        cc:                                           
             
                    t.com>               Subject:     RE: Database problems            
             
                                                                                       
             
                    08/11/2000                                                         
             
                    11:45 AM                                                           
             
                    Please                                                             
             
                    respond to                                                         
             
                    cf-talk                                                            
             
                                                                                       
             
                                                                                       
             






Can we see some code?  You may be nesting your tags incorrectly.

--K

Katrina,

I think the code's fine, but here is the action template, anyway.

Thanks,
--John

<cftransaction>
<cfquery datasource="county">
insert into LINKS
           (APPROVE,
           TYPE_DESC,
           MAIN_NBR,
           LINK)
values
           ('#form.APPROVE#',
           '#form.TYPE_DESC#',
           '#form.MAIN_NBR#',
           '#form.LINK#')
</cfquery>

<cfquery name="getid" datasource="county">
     select max(record) as newrecord
     from links
</cfquery>

<cfset record = #getid.newrecord#>

<cflocation url="link_add.cfm">
</cftransaction>


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.