473,327 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

javascript in a query's text string

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

Jul 6 '06 #1
5 2379
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" <ka********@yahoo.grwrote in message
news:e8***********@ulysses.noc.ntua.gr...
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

Jul 6 '06 #2
Larry,

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

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)?

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" <ka********@yahoo.grwrote in message
news:e8***********@ulysses.noc.ntua.gr...
>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
Jul 6 '06 #3
"geotso" <ka********@yahoo.grwrote
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" <ka********@yahoo.grwrote in message
news:e8***********@ulysses.noc.ntua.gr...
>>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

Jul 7 '06 #4
I'm afraid that something is wrong, because I get an error when I try to use
the IIf function. According your suggestion the text string became:

strText: (IIf IsNull([caldInfo]), "<a href=""javascript:;""
onClick=""MM_openBrWindow('../calendar/" & [caldID] & ".htm','" &
[newWinName] & "','status=1,scrollbars=1," & [newWinW] & "," & [newWinH] &
"')"">Details...</a>", "")

The error message is: "You must enclose IIf function arguments in
parentheses" and when I close the message, the cursor has been inserted
after the IsNull opening parenthesis.

Do you see something wrong that I don't?

Yet, thanks again for your help

then, "Larry Linson" mounted the rostrum and spoke like this:
"geotso" <ka********@yahoo.grwrote
>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" <ka********@yahoo.grwrote in message
news:e8***********@ulysses.noc.ntua.gr...
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

Jul 9 '06 #5

"geotso" <ka********@yahoo.grwrote in message
news:e8***********@ulysses.noc.ntua.gr...
I'm afraid that something is wrong, because I get an error when I try to
use the IIf function. According your suggestion the text string became:

strText: (IIf IsNull([caldInfo]), "<a href=""javascript:;""
onClick=""MM_openBrWindow('../calendar/" & [caldID] & ".htm','" &
[newWinName] & "','status=1,scrollbars=1," & [newWinW] & "," & [newWinH] &
"')"">Details...</a>", "")

The error message is: "You must enclose IIf function arguments in
parentheses" and when I close the message, the cursor has been inserted
after the IsNull opening parenthesis.

Do you see something wrong that I don't?
IIFs with long, complex text strings can be hard to diagnose. Consider
putting that into a function in a standard module, which you can test using
the immediate window, so that you aren't trying to debug a complex
expression by running the query that contains it.

Then you'd use it with something similar to:

strText = MyNewFunction([caldInfo])

Larry Linson
Microsoft Access MVP

Larry


Jul 9 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Michelle Keys | last post by:
I am trying to call a print function to print a string from a database using javascript. Which is RC_DATA of Varchar2(2500). This is a javascript is not being used. I have a thing that needs to...
2
by: Alex | last post by:
Hi all, I'm writing a small web application which searches a database based on a date field, and populates a datagrid control with the results. The datagrid control has selection buttons added...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.