| led_belly 2006-08-21, 6:59 pm |
|
I am trying to setup a cross-linked select box based on the info presented
below. For some reason FormBuilder isn't presenting the cross linked form
element.
I have the following DB tables/fields:
[ga_merchants]
merchantid
....
[ga_categories]
categoryid
....
[ga_merchant_categories]
merchantid
categoryid
My links.ini file is setup as follows:
[ga_merchants]
merchantid =3D ga_merchant_categories:merchantid
[ga_merchant_categories]
merchantid =3D ga_merchants:merchantid
categoryid =3D ga_categories:categoryid
[ga_categories]
categoryid =3D ga_deal_categories:categoryid
categoryid =3D ga_merchant_categories:categoryid
I have the following set in the Ga_merchants class:
var $fb_crossLinks =3D array(array('table' =3D> 'ga_merchant_categories=
',
'fromField' =3D> 'merchantid',
'toField' =3D> 'categoryid',
'type' =3D> 'select'));
The debug output is as follows:
Array ( [id] =3D> 13 [op] =3D> edit [process] =3D> Go > ) ga_merchants: CON=
NECT:
Checking for database database_ in options
ga_merchants: CONNECT: NEW CONNECTION
ga_merchants: CONNECT: mysql://gotapex:***@192.168.0.7/gotapex_vb354
78860d6931124e3a7c2d43153e076464
ga_merchants: CONNECT:
a:1:{s:32:"78860d6931124e3a7c2d43153e076464";O:8:"db_mysql":8:{s:10:"autoco=
mmit";b:1;s:8:"dbsyntax";s:5:"mysql";s:3:"dsn";a:9:{s:7:"phptype";s:5:"mysq=
l";s:8:"dbsyntax";s:5:"mysql";s:8:"username";s:7:"gotapex";s:8:"password";s=
:15:"SDFgn4iu38GEGre";s:8:"protocol";s:3:"tcp";s:8:"hostspec";s:11:"192.168=
..0.7";s:4:"port";b:0;s:6:"socket";b:0;s:8:"database";s:13:"gotapex_vb354";}=
s:8:"features";a:7:{s:5:"limit";s:5:"alter";s:8:"new_link";s:5:"4.2.0";s:7:=
"numrows";b:1;s:8:"pconnect";b:1;s:7:"prepare";b:0;s:3:"ssl";b:0;s:12:"tran=
sactions";b:1;}s:9:"fetchmode";i:1;s:22:"fetchmode_object_class";s:8:"stdCl=
ass";s:7:"options";a:8:{s:16:"result_buffering";i:500;s:10:"persistent";b:0=
;s:3:"ssl";b:0;s:5:"debug";i:0;s:14:"seqname_format";s:6:"%s_seq";s:8:"auto=
free";b:0;s:11:"portability";i:0;s:8:"optimize";s:11:"performance";}s:13:"w=
as_connected";b:1;}}
ga_merchants: databaseStructure: Loaded ini file: ../etc/gotapex_vb354.ini
ga_merchants: GET: merchantid 13 Array
(
[0] =3D> merchantid
)
ga_merchants: find: 1
ga_merchants: QUERY: SELECT *
FROM ga_merchants
WHERE ( ga_merchants.merchantid =3D 13 )
ga_merchants: query: QUERY DONE IN 0.00085687637329102 seconds
ga_merchants: RESULT:
O:9:"db_result":11:{s:8:"autofree";b:0;s:3:"dbh";O:8:"db_mysql":8:{s:10:"au=
tocommit";b:1;s:8:"dbsyntax";s:5:"mysql";s:3:"dsn";a:9:{s:7:"phptype";s:5:"=
mysql";s:8:"dbsyntax";s:5:"mysql";s:8:"username";s:7:"gotapex";s:8:"passwor=
d";s:15:"SDFgn4iu38GEGre";s:8:"protocol";s:3:"tcp";s:8:"hostspec";s:11:"192=
..168.0.7";s:4:"port";b:0;s:6:"socket";b:0;s:8:"database";s:13:"gotapex_vb35=
4";}s:8:"features";a:7:{s:5:"limit";s:5:"alter";s:8:"new_link";s:5:"4.2.0";=
s:7:"numrows";b:1;s:8:"pconnect";b:1;s:7:"prepare";b:0;s:3:"ssl";b:0;s:12:"=
transactions";b:1;}s:9:"fetchmode";i:1;s:22:"fetchmode_object_class";s:8:"s=
tdClass";s:7:"options";a:8:{s:16:"result_buffering";i:500;s:10:"persistent"=
;b:0;s:3:"ssl";b:0;s:5:"debug";i:0;s:14:"seqname_format";s:6:"%s_seq";s:8:"=
autofree";b:0;s:11:"portability";i:0;s:8:"optimize";s:11:"performance";}s:1=
3:"was_connected";b:1;}s:9:"fetchmode";i:1;s:22:"fetchmode_object_class";s:=
8:"stdClass";s:11:"limit_count";N;s:10:"limit_from";N;s:10:"parameters";a:0=
:{}s:5:"query";s:81:"SELECT
*
FROM ga_merchants
WHERE ( ga_merchants.merchantid =3D 13 )
";s:6:"result";i:0;s:11:"row_counter";N;s:9:"statement";N;}
ga_merchants: find: CHECK autofetchd 1
ga_merchants: find: ABOUT TO AUTOFETCH
ga_merchants: FETCH:
a:11:{s:10:"merchantid";s:2:"13";s:8:"legacyid";s:1:"1";s:13:"alphanumindex=
";s:1:"1";s:8:"merchant";s:14:"123Inkjets.com";s:7:"website";N;s:8:"urlstar=
t";s:40:"http://www.qksrv.net/click-268435-512018";s:9:"urlmiddle";s:5:"?si=
d=3D";s:6:"urlend";s:8:"&afsrc=3D1";s:6:"active";s:1:"1";s:12:"totalcoupons=
";s:1:"7";s:12:"validcoupons";s:1:"7";}
ga_merchants: fetchrow LINE: merchantid =3D 13
ga_merchants: fetchrow LINE: legacyid =3D 1
ga_merchants: fetchrow LINE: alphanumindex =3D 1
ga_merchants: fetchrow LINE: merchant =3D 123Inkjets.com
ga_merchants: fetchrow LINE: website =3D
ga_merchants: fetchrow LINE: urlstart =3D
http://www.qksrv.net/click-268435-512018
ga_merchants: fetchrow LINE: urlmiddle =3D ?sid=3D
ga_merchants: fetchrow LINE: urlend =3D &afsrc=3D1
ga_merchants: fetchrow LINE: active =3D 1
ga_merchants: fetchrow LINE: totalcoupons =3D 7
ga_merchants: fetchrow LINE: validcoupons =3D 7
ga_merchants: fetchrow: ga_merchants DONE
ga_merchants: find: DONE
ga_merchant_categories: CONNECT: Checking for database database_ in options
ga_merchant_categories: CONNECT: USING CACHED CONNECTION
ga_merchant_categories: links: Loaded links.ini file:
.../etc/gotapex_vb354.links.ini
FormBuilder:=20
....reorder not supported, fb_preDefOrder is not set or is not an array,
returning _getFieldsToRender...
FormBuilder: Setting rule for merchant
a:3:{s:9:"validator";s:8:"required";s:4:"rule";b:0;s:7:"message";s:25:"The
field %s is required.";}
FormBuilder: Adding required rule for merchant
And, just for the hell of it, here's the HTML output:
<form action=3D"/dev.gotapex.com/trunk/pub/gotapex/admin/ga_merchants.php"
method=3D"post" name=3D"ga_merchants" id=3D"ga_merchants" target=3D"_self">
<div>
<input name=3D"_qf__ga_merchants" type=3D"hidden" value=3D"" />
<input name=3D"merchantid" type=3D"hidden" value=3D"13" />
<input name=3D"op" type=3D"hidden" value=3D"edit" />
<table border=3D"0">
=09<tr>
=09=09<td align=3D"right" valign=3D"top"><span style=3D"color:
#ff0000">*</span>Merchant</td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"merchant" type=3D"te=
xt"
value=3D"123Inkjets.com" /></td>
=09</tr>
=09<tr>
=09=09<td align=3D"right" valign=3D"top">Urlstart</td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"urlstart" type=3D"te=
xt"
value=3D"http://www.qksrv.net/click-268435-512018" /></td>
=09</tr>
=09<tr>
=09=09<td align=3D"right" valign=3D"top">Urlmiddle</td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"urlmiddle" type=3D"t=
ext"
value=3D"?sid=3D" /></td>
=09</tr>
=09<tr>
=09=09<td align=3D"right" valign=3D"top">Urlend</td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"urlend" type=3D"text=
"
value=3D"&afsrc=3D1" /></td>
=09</tr>
=09<tr>
=09=09<td align=3D"right" valign=3D"top">Active</td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"active" type=3D"chec=
kbox"
value=3D"1" id=3D"qf_5070f2" checked=3D"checked" /></td>
=09</tr>
=09<tr>
=09=09<td align=3D"right" valign=3D"top"></td>
=09=09<td valign=3D"top" align=3D"left"><input name=3D"__submit__" value=3D=
"Submit"
type=3D"submit" /></td>
=09</tr>
=09<tr>
=09=09<td></td>
=09<td align=3D"left" valign=3D"top"><span style=3D"font-size:80%;
color:#ff0000;">*</span><span style=3D"font-size:80%;"> denotes required
field</span></td>
=09</tr>
</table>
</div>
</form>
Any help is much appreciated!
--=20
View this message in context: http://www.nabble.com/FormBuilder-Crosslinks-=
Problem-tf2143615.html#a5917424
Sent from the Pear - General forum at Nabble.com.
|