Query Problem

[Former Member]

hi,

I want to execute this query

select * from '[Param.1]'. param.1 value will be pass from html page. result set of this query must be shown in iGrid. I executed this one by using iGrid. but it shows error at <appletname>.executeCommand is not property of this applet. how can i pass the vales to this query and how can i display it in iGrid?please help me..

- senthil

[Former Member]

the executeCommand method should only be used for iCommand queries.

In your iGrid applet add a parameter like:

<param name="Param.1" value="">

where value is passed from the html page.

Or assign it via javascript:

document.myApplet.getQueryObject().setParam(1, value)

document.myApplet.updateGrid(true)

[Former Member]

Hi,

i tried this. but in java console it display as I

ERROR - Unable To Obtain Column getKeys

ERROR - A SQL Error has occurred on query, [<system name>]Line 1: Incorrect syntax near '<table name>'..

in query template i give query as fixed query as select * from '[Param.1]'.

in javascript i set it as

document.myapplet.getQueryObject().setParam(1,value)

document.myapplet.updateGrid(true)

document.myapplet.refresh()

What to do?

- senthil

[Former Member]

remove the single quotes from around [Param.1].

[jcgood25]

It doesn't make any sense to do an .updateGrid(true); followed by a refresh(); since this will make the query run twice. Just eliminate the refresh() call.

Regards,

Jeremy

[Former Member]

Hi,

its working now. i removed ' ' marks. and also refresh option. now its working.

thanks

- senthil