Re: javascript in a query's text string

"geotso" <kata-ye-xi@xxxxxxxx> wrote

Thank you very much for your answer, that
was the solution to my basic problem.

You are welcome. I'm glad I was able to assist.

Now, can you (or someone else) please explain to me how to limit the
contents of the column shown the text string so, only the cells where the
record's[caldInfo].Value Is Null (Problem No1 in my first post)?

In the Query Builder, the CalculatedField would be:

FieldNameYouLike: (IIF IsNull([caldInfo]), "your text string", "")

Best of luck with your application.

Larry Linson
Microsoft Access MVP



Please note that I've already found a (temporary) solution, using VBScript
in my .asp page, but I would like to know if there is a solution into the
database area.

Thank you again...

then, "Larry Linson" mounted the rostrum and spoke like this:

For Access/Jet SQL: If you are enclosing the string in double-quotes,
double each internal double-quote, and don't change the single quotes,
e.g., "The man said, ""Hello. Would you like a 'near-beer'?"""

Larry Linson
Microsoft Access MVP

"geotso" <kata-ye-xi@xxxxxxxx> wrote in message
news:e8j9aj$1fj6$1@xxxxxxxxxxxxxxxxxxxxxx
Here is the scenario:

1. I have a table (tblCalendar) with the following fields:
caldID
caldDate
caldTitle
caldInfo
nWinW
nWinH

2. By design, when [caldInfo].value Is Null, [nWinW] and [nWinH] are
both
Not Null

3. In order to filter and sort the data (because I want it for an .asp
page) there is a query displaying the first four fields.

4. Problem No1: I want to add a fifth field (column) in the query, that
will display a text string ONLY WHEN the corresponding [caldInfo].value
Is Null.

5. Problem No2: That text string is the following javascript command:
<a href="javascript:;" onClick="MM_openBrWindow('filePath','winName',
'status=1,winWidth,winHeight')">Details...</a>

6. Furthermore, the arguments of MM_openBrWindow() should be replaced by
the following text/fieldnames:

filePath = ../calendar/[caldID].htm
winName = htm[caldID]
status=1 = status=1 (the same)
winWidth = [nWinW]
winHeight = [nWinH]

The general idea is that I don't know how to replace/escape the
single/double quotes of the javascript, that should be inside the double
quotes of the text string in the query.

Can you help me please?

------- ---- --- -- - -
[gt] aka geotso
------- ---- --- -- - -
Please, remove hyphens to contact me



.

Relevant Pages

  • Re: Problems with Delete Command
    ... The SQL could get fairly messy if you need to construct it in code, ... ContactID, and WebComID, and create your on-the-fly SQL on that saved query, ... to find the list of ContactIDs from the junction table, ... This is a style/readability thing: if you are going to use string ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: Need help with Code Please!!!
    ... putting the query SQL itself in here maybe it will help you understand what I ... the actual string that gets built at the end of the SQ1 build process. ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ... Dim qd As QueryDef 'object ref to query item ...
    (microsoft.public.access.formscoding)
  • Re: Need help with Code Please!!!
    ... the actual string that gets built at the end of the SQ1 build process. ... The message says Syntax error in query expression ... Dim rs As Recordset 'object ref to qryCompany\USFNumber ...
    (microsoft.public.access.formscoding)
  • Re: javascript in a querys text string
    ... Now, can you please explain to me how to limit the contents of the column shown the text string so, only the cells where the record's.Value Is Null? ... double each internal double-quote, and don't change the single quotes, ... page) there is a query displaying the first four fields. ... The general idea is that I don't know how to replace/escape the ...
    (comp.databases.ms-access)