Hi... I am trying to design my first Data Access Page and I have a really simple syntax question. I need to know the proper syntax for Microsoft Script for the following:
Ser = chr(34) & "LogicalCubeName=" & LogicalCubeName.value & chr(34)
This script works perfectly well if LogicalCubeName is a Numeric Data Type. What, however, is the proper syntax if LogicalCubeName is a String? In VBA it would be very simple, add the additional 1/2 quote marks:
Ser = chr(34) & '"LogicalCubeName="' & LogicalCubeName.value & chr(34)
but when I try this syntax, LogicalCubeName becomes Green similar to if I am trying to 'nest' comments in VB.
Can someone assist me with this real simple question?
Thanks
Pat
Ser = chr(34) & "LogicalCubeName=" & LogicalCubeName.value & chr(34)
This script works perfectly well if LogicalCubeName is a Numeric Data Type. What, however, is the proper syntax if LogicalCubeName is a String? In VBA it would be very simple, add the additional 1/2 quote marks:
Ser = chr(34) & '"LogicalCubeName="' & LogicalCubeName.value & chr(34)
but when I try this syntax, LogicalCubeName becomes Green similar to if I am trying to 'nest' comments in VB.
Can someone assist me with this real simple question?
Thanks
Pat