Re: Display from MySQL Text Field

Hi,

It looks like something to do with alias.
I am using aliases and that is the problem i found.
I am pasting my query:
           SELECT
		`Properties`.`idProperties`,
		`Properties`.`Details` AS `pDetails`,
		`Properties`.`Price`,
		`PropType`.`TypeName`,
		`TypeSpecs`.`Spec`,
		`PropertyTypeSpec`.`Details` AS `sDetails`,
		`PropertyTypeSpec`.`YesNo`,
		`PropertyTypeSpec`.`Nums`,
		`TypeSpecs`.`DisplayType`,
		`PropNumber`.`idusers`,
		`TypeSpecs`.`idPropType`,
		`PropType`.`DateUpdated`
		FROM
		`Properties`
		Inner Join `PropNumber` ON `PropNumber`.`idPropNumber` =
`Properties`.`idPropNumber`
		Inner Join `PropType` ON `PropType`.`idPropType` =
`Properties`.`idPropType`
		Inner Join `PropertyTypeSpec` ON `Properties`.`idProperties` =
`PropertyTypeSpec`.`idProperties`
		Inner Join `TypeSpecs` ON `TypeSpecs`.`idTypeSpecs` =
`PropertyTypeSpec`.`idTypeSpecs` AND `PropType`.`idPropType` =
`TypeSpecs`.`idPropType`
		WHERE
		`Properties`.`idProperties` IN  ('25', '26')

now if i remove `PropertyTypeSpec`.`Details` AS `sDetails` and remove
`pDetails` alias, it start showing details.

Is there any solution where i don't have to change column name in database
table ?

Regards,
Farhan



On 10/3/06, mmfarhan <[email protected]> wrote:
>
> Hi,
> I am trying to display text which is stored in mysql text field. But it
> displays nothing. and when i try this code:
> <c:out value="${rowSrearch.pDetails}" />
<snip/>

Could simply be EL-2 [1]. Try changing property name to 'pdetails' (or
some such).

-Rahul

[1] https://issues.apache.org/jira/browse/EL-2
-- 
View this message in context: http://www.nabble.com/Display-from-MySQL-Text-Field-tf2377092.html#a6638060
Sent from the Taglibs - User mailing list archive at Nabble.com.