rumex
Založený: 27.10.2017
Príspevky: 7
Zaslal: 2017-10-27 13:40
Návrat hore
Odpovedať s citátom
|
Hi Doug
I want to click a record and open a different form. The different form will filter by a value from the row.
I am not able to add to the URL a value from the table when I have performed a lookup from a different table. I want the foreign key 'AgencyId' and not the 'name' of the agency. Can you help?
---
I have two mysql tables:
agent has ID, name, AgencyID fields
agency has ID, name
I want to open a form showing all agents. Click an agent and have the agency form open, filtered by AgencyId.
/****
*** NAVIGATION from agent form to agency form ***
*** I want this to open the form and for the ***
*** form to only display this agency. ***
*** The database table key is AgencyId ***
****/
$opts['fdd']['AgencyId'] = array(
'name' => 'Agency',
// *** The lookup and the display are different here.
'values' => array('table' => 'agency', 'column' => 'id', 'description' => 'name'),
'URL' => 'http://localhost:81/html/agenter/agency.php?agencyId=$value',
'select' => 'T',
'maxlen' => 11,
'sort' => true
);
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2017-10-27 18:46
Návrat hore
Odpovedať s citátom
|
I don't know, not functioning well today, see some examples.
https://www.phpvs.com/xmfg/txt/lookups.txt
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2017-10-29 01:58
Návrat hore
Odpovedať s citátom
|
Skip the URL option and use CONCAT to create the link. Search the forum for CONCAT examples, the example below is what I had nearby and perhaps it will give you an idea.
$opts['fdd']['dummy2'] = array (
'name' => 'Thumbnail',
'sql|VLF' => 'if(category = "other",
CONCAT("<a href=\"", dir, "/", filename, "\" target=\"_blank\">link</a>"),
if(category = "thumb", CONCAT("<a rel=\"example_group\" href=\"", REPLACE(dir, "/tn", "/"), filename, "\" target=\"_blank\"><img src=\"", dir, "/", filename, "\" ", " alt=\"\" border=\"0\"></a><br><a href=\"fancybox.change.php?upld_id=", upld_id, "\">Replace</a>"), ""))',
'options' => 'VLF',
'input' => 'R',
'escape' => false,
'sort' => false
);
$opts['fdd']['logon_url'] = array(
'default' => '',
'input' => '',
'maxlen' => 255,
'name' => 'Logon URL',
'options' => 'XACPVD',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'tab|ACPV' => 'LOGON URL',
'sort' => true,
'escape' => false,
'sql|LFV' => 'if(logon_url > "", CONCAT("<a href=\"", logon_url, "\" target=\"_blank\"", " title=\"", logon_url ,"\"", ">Go There</a>"), "")'
);
|
doug
Založený: 10.02.2003
Príspevky: 1013
Bydlisko: Denver, Colorado (USA)
Zaslal: 2017-10-29 02:06
Návrat hore
Odpovedať s citátom
|
'sql|LFV' => 'if(AgencyId > "0", CONCAT("<a href=\"otherPage.php?agencyID=", AgencyId, "\" target=\"_blank\"", " title=\"", AgencyId ,"\"", ">AgencyId</a>"), "")'
|
rumex
Založený: 27.10.2017
Príspevky: 7
Zaslal: 2017-11-07 15:49
Návrat hore
Odpovedať s citátom
|
Thanks, I put those together and got the following working
$opts['fdd']['NavParent'] = array (
'name' => 'GO',
//_self - open over current page
'sql|LFV' => 'if(AgencyId > "0", CONCAT("<a href=\"agency.php?agencyId=", AgencyId, "\" target=\"_self\"", " title=\"", AgencyId ,"\"", ">GO</a>"), "")',
'options' => 'L', // only visible on list
'input' => 'R', // no sql write
'escape' => false,
'sort' => false
);
|
jognahartu
Založený: 06.12.2021
Príspevky: 2264
Zaslal: 2022-01-24 15:25
Návrat hore
Odpovedať s citátom
|
I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.
토토커뮤니티
|
richard68stewart
Založený: 24.01.2022
Príspevky: 1
Zaslal: 2022-01-24 16:58
Návrat hore
Odpovedať s citátom
|
Pro Evolution Soccer Crack is no exception. An attempt has been made to close the gap with its competition "EA Sports FIFA," however it falls far short in terms of depth and variety. Those who prefer the gameplay of "PES "can still find it good enough to compensate for the missing areas.
https://connectcrack.com/pro-evolution-soccer-crack-latest-version-download/
|
AliAhern
Založený: 09.10.2020
Príspevky: 4
Zaslal: 2022-01-31 08:41
Návrat hore
Odpovedať s citátom
|
Truly, the significance of this entryway is without a doubt and fine art in this entryway is so mind blowing. I for one analyze this entryway and work of art which is looking a lot of great and also check
essay writing service reviews
to manage the task. Much obliged to you for sharing this brilliant and astonishing data.
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-02-16 08:50
Návrat hore
Odpovedať s citátom
|
This article was written by a real thinking writer. I agree many of the with the solid points made by the writer. I’ll be back.
resurfacing machines
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-02-23 18:50
Návrat hore
Odpovedať s citátom
|
I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work...
slotxo เว็บตรง
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-02-24 19:52
Návrat hore
Odpovedať s citátom
|
Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work.
Telephonic Interpretation Services
|
techsquad2
Založený: 08.04.2021
Príspevky: 55
Zaslal: 2022-02-25 08:18
Návrat hore
Odpovedať s citátom
|
Log into your account and
block Malwarebytes popups
easily. You need to find the popups notification option under the general setting tab in your Malwarebytes account.
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-02-26 20:08
Návrat hore
Odpovedať s citátom
|
This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post.
practice karambit
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-03-03 21:17
Návrat hore
Odpovedať s citátom
|
Wow, excellent post. I'd like to draft like this too - taking time and real hard work to make a great article. This post has encouraged me to write some posts that I am going to write soon.
Groothandel in verpakkingsmaterialen
|
Holly Lewis
Založený: 02.09.2021
Príspevky: 870
Zaslal: 2022-03-07 19:51
Návrat hore
Odpovedať s citátom
|
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!
elo boost wild rift
|
Odoslať novú tému
Odpovedať na tému
Choď na stránku 1, 2, 3 ... 11, 12, 13 Ďalší
|
|
|
|