Home › Forums › Support › BiblioWeb

Possible? Create a hyperlink to search results for a RefID (What's the SQL Command for a RefID search?)?

Mon, 10/29/2007 - 02:49 — BDudek

What would a URL like the one below look like if it was searching for RefID 38 instead of titles containing the word "Synthesis?"
http://128.192.2.200:8002/bw_login2srch?edit_loginname=guest&edit_password=guest&bw_search_adv?sql=select+bib.*+from+bib+where+bib.title+like+'%25Synthesis%25'
I don't want to link directly to record 38; I want the link to lead to a search results page (bw_ref_list_bib.htm) with a link to record 38 on it.

Thanks,
Ben

‹ Abstract New Lines Ignored By BiblioWeb? Possible? Disable highlighting? ›
Mon, 10/29/2007 - 15:20 — Paul Chen

Please try this: replace

Please try this: replace "where+bib.title+like+'%25Synthesis%25'" with "where+bib.Ref_ID=38".

Wed, 10/31/2007 - 13:53 — BDudek

Re: Possible? Create a hyperlink to search results for a RefID (

Your suggestion worked, Paul, but only after I added "+&hiwords=" to the end of the URL. I had removed that code because I didn't want anything highlighted. It turns out that the URL doesn't work without it, instead producing a "EXCEPTION: No SQL statement available" error. So, I restored it and left off any words so, still, nothing would be highlighted. :)

Thanks,
Ben