W
wallaceb
Guest
Is there a way to pass a query to dadabik in a url? For instance, I have a database where every record has a year associated; what I'd like to do is pass it something like Year=2000. Is that possible? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eugenio
Guest
wallaceb wrote:
>
> Is there a way to pass a query to dadabik in a url? For
> instance, I have a database where every record has a year
> associated; what I'd like to do is pass it something like
> Year=2000. Is that possible? Thanks!
Sure, try to serch something and then click on a coloumn to order by the corresponding field. Now look at the url, you should se, among other things, where_clause=...., this is the where clause of the SELECT statement; try modifying it.
Eugenio.
(Latest version of DaDaBIK when this message was posted: 2.2.1)
>
> Is there a way to pass a query to dadabik in a url? For
> instance, I have a database where every record has a year
> associated; what I'd like to do is pass it something like
> Year=2000. Is that possible? Thanks!
Sure, try to serch something and then click on a coloumn to order by the corresponding field. Now look at the url, you should se, among other things, where_clause=...., this is the where clause of the SELECT statement; try modifying it.
Eugenio.
(Latest version of DaDaBIK when this message was posted: 2.2.1)
C
CJ
Guest
I don't see any where_clause in the URL...
W
wallaceb
Guest
If you follow Eugenio's instructions you will. You have to click on a column to order by the corresponding field to see the WHERE statement.
C
CJ
Guest
I have done that before, and after, and I don't see the WHERE statement there.
xxxxxxx/data/form.php?&table_name=customer_info&function=search&sql=&name_mailing=&page=0&order=state
xxxxxxx/data/form.php?&table_name=customer_info&function=search&sql=&name_mailing=&page=0&order=state
P
PLMresearch
Guest
Here's what I use (In thiws case, I am searching on the field named products_lock equal to Y):
xxxxxx/upsd/program_files/form.php?function=search&sql=where`products_lock`='Y'&page=0&table_name=lamps
The code looks like:
<?php echo $normal_messages_ar["show_outstanding"]; ?>
Hope this helps.
xxxxxx/upsd/program_files/form.php?function=search&sql=where`products_lock`='Y'&page=0&table_name=lamps
The code looks like:
<?php echo $normal_messages_ar["show_outstanding"]; ?>
Hope this helps.
E
Eugenio
Guest
PLMresearch wrote:
> Here's what I use (In thiws case, I am searching on the field
> named products_lock equal to Y):
>
>
> xxxxxx/upsd/program_files/form.php?function=search&sql=where`products_lock`='Y'&page=0&table_name=lamps
>
> The code looks like:
>
> <?php echo
> $normal_messages_ar["show_outstanding"]; ?>
At the beginning of sql= DaDaBIK needs a blank space, so:
sql=+where.....
all the where clause is urlencoded.
Eugenio.
(Latest version of DaDaBIK when this message was posted: 2.2.1)
> Here's what I use (In thiws case, I am searching on the field
> named products_lock equal to Y):
>
>
> xxxxxx/upsd/program_files/form.php?function=search&sql=where`products_lock`='Y'&page=0&table_name=lamps
>
> The code looks like:
>
> <?php echo
> $normal_messages_ar["show_outstanding"]; ?>
At the beginning of sql= DaDaBIK needs a blank space, so:
sql=+where.....
all the where clause is urlencoded.
Eugenio.
(Latest version of DaDaBIK when this message was posted: 2.2.1)