<cfcontent type="text/html;charset=iso-8859-1">
<cfprocessingDirective pageencoding="iso-8859-1">
<cfset setEncoding("Form", "ISO-8859-15")>
<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">

<Cfset pairs = rereplace(form.addguides,',','|','ALL')>

<cfset pairs = reMatch(
    "[^|]+\|[^|]+",
    pairs
    ) />
 
<!---
    At this point, our pairs contains a bunch of smaller lists,
    each with two values: our date and our amount. This list is
    pipe-delimited and can be easily parsed:
--->
<cfset cat = "">
<cfloop
    index="pair"
    array="#pairs#">
 <Cfoutput>
    


    
    <b>ID: #listFirst( pair, "|" )#,
    CatID: #listLast( pair, "|" )#</b>
<Br>
<Cfif cat is not #listLast( pair, "|" )#>
<Cfset cat = #listLast( pair, "|" )#>
<cfquery name=addphoto datasource="#ds#">
INSERT INTO issueguide(catid,pkid,writeup,offer,expirationdate)
VALUES	(#listLast( pair, "|" )#,#url.id#,'','','')
</cfquery>
</Cfif>

<cfquery name="Getlastid" dataSource="#ds#">
	select id from issueguide order by id desc limit 0,1
</cfquery>	

<Cfquery name="getissmags" dataSource="#ds#">
	select month,mags from newwriteupmaster
	where id = #listFirst( pair, "|" )#
</cfquery>

<cfquery name=addphoto datasource="#ds#">
INSERT INTO issueguidecat(issueguideid,issue,mags,pickup)
VALUES	(#getlastid.id#,'#dateformat(getissmags.month,'mmmm yyyy')#','#getissmags.mags#','')
</cfquery>

<p>



    </Cfoutput>
    <br />
 
</cfloop>

<cflocation url="addguide.cfm?id=#url.id#" addtoken="no">


<!---

<cfloop list="#form.addguides#" index="i">

<cfoutput>
	INSERT INTO issueguide(catid,pkid,writeup,offer,expirationdate)
VALUES	(#i#,#url.id#,'','','')
<p>
	 </cfoutput>
</CFLOOP>

<cfquery name=addphoto datasource="#ds#">
INSERT INTO issueguide(catid,pkid,writeup,offer,expirationdate)
VALUES	(#form.catid#,#url.id#,'','','')
</cfquery>


<cflocation url="addguide2015.cfm?id=#url.id#" addtoken="no">
--->