Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SetColumnLink - Error with multiple parameters

4 posts in PowerSite specific Last posting was on 2001-02-23 05:09:11.0Z
lichn Posted on 2001-02-21 15:33:47.0Z
Newsgroups: sybase.public.powersite
From: lichn
Date: Wed, 21 Feb 2001 10:33:47 -0500
Subject: SetColumnLink - Error with multiple parameters
Lines: 30
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <382_27A5A4090E26B10800557D9B852569FA.00557D92852569FA@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powersite:274
Article PK: 862672

I'm at my wits end and need a new set of eyes to look at my SetColumnLink.
I can't seem to get rid of the "syntax error". What am I missing? I have
read the manuals and other information in the newgroup, but have not been
able to fix this.

Here is my setcolumnlink from my page.

dwData.setcolumnlink( "ssn", "employees_detail.htm", "rowid='rowid +
\"\"'|ssn='ssn + \"\"", "");
dwData.setcolumnlink("per_employee_name", "employees_detail.htm",
"rowid='rowid + \"\"'|ssn='ssn + \"\"", "");

Here is the syntax error in the log.

Feb 21 09:45:33 2001: HTMLDW: Entering
SetColumnLink('ssn','employees_detail.htm','rowid='rowid + ""'|ssn='ssn +
""')
Feb 21 09:45:33 2001: HTMLDW: Exiting SetColumnLink() = 'Line 1 Column 59:
incorrect syntax.'
Feb 21 09:45:33 2001: HTMLDW: EnableCommit()
Feb 21 09:45:33 2001: HTMLDW: Entering
SetColumnLink('per_employee_name','employees_detail.htm','rowid='rowid +
""'|ssn='ssn + ""')
Feb 21 09:45:33 2001: HTMLDW: Exiting SetColumnLink() = 'Line 1 Column 73:
incorrect syntax.'

Does anyone know where the "Column" is that is referenced in the error
line? I have attempted to find "Column 59 and 73", without success.

Any help is appreciated. Thanks.


Larry Cermak [Team Sybase] Posted on 2001-02-22 04:39:45.0Z
Newsgroups: sybase.public.powersite
From: "Larry Cermak [Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: SetColumnLink - Error with multiple parameters
Date: Wed, 21 Feb 2001 21:39:45 -0700
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: node-64-248-206-25.dslspeed.zyan.com 64.248.206.25
Message-ID: <382_2YyRaOInAHA.161@forums.sybase.com>
References: <382_27A5A4090E26B10800557D9B852569FA.00557D92852569FA@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:273
Article PK: 840530

rowid is a numeric column, right? Remove the single quotes around that and
see if it helps.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc
EAServer Consulting and Training

Now Available: The Web DataWindow eBook

Web DataWindow Articles: http://my.sybase.com/detail?id=1003371

<lichn> wrote in message
news:27A5A4090E26B10800557D9B852569FA.00557D92852569FA@webforums...
> I'm at my wits end and need a new set of eyes to look at my SetColumnLink.
> I can't seem to get rid of the "syntax error". What am I missing? I have
> read the manuals and other information in the newgroup, but have not been
> able to fix this.
>
> Here is my setcolumnlink from my page.
>
> dwData.setcolumnlink( "ssn", "employees_detail.htm", "rowid='rowid +
> \"\"'|ssn='ssn + \"\"", "");
> dwData.setcolumnlink("per_employee_name", "employees_detail.htm",
> "rowid='rowid + \"\"'|ssn='ssn + \"\"", "");
>
> Here is the syntax error in the log.
>
> Feb 21 09:45:33 2001: HTMLDW: Entering
> SetColumnLink('ssn','employees_detail.htm','rowid='rowid + ""'|ssn='ssn +
> ""')
> Feb 21 09:45:33 2001: HTMLDW: Exiting SetColumnLink() = 'Line 1 Column
59:
> incorrect syntax.'
> Feb 21 09:45:33 2001: HTMLDW: EnableCommit()
> Feb 21 09:45:33 2001: HTMLDW: Entering
> SetColumnLink('per_employee_name','employees_detail.htm','rowid='rowid +
> ""'|ssn='ssn + ""')
> Feb 21 09:45:33 2001: HTMLDW: Exiting SetColumnLink() = 'Line 1 Column
73:
> incorrect syntax.'
>
> Does anyone know where the "Column" is that is referenced in the error
> line? I have attempted to find "Column 59 and 73", without success.
>
> Any help is appreciated. Thanks.
>


lichn Posted on 2001-02-22 13:43:03.0Z
Newsgroups: sybase.public.powersite
From: lichn
Date: Thu, 22 Feb 2001 08:43:03 -0500
Subject: Re: SetColumnLink - Error with multiple parameters
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <382_E7A9CF4162F6CA38004B5A50852569FB.0016E78A852569FB@webforums>
References: <382_27A5A4090E26B10800557D9B852569FA.00557D92852569FA@webforums> <382_2YyRaOInAHA.161@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powersite:272
Article PK: 862667

Thanks, I made so many changes to try and fix it. Tell me where can "The
Web DataWindow eBook" be purchased?


Larry Cermak [Team Sybase] Posted on 2001-02-23 05:09:11.0Z
Newsgroups: sybase.public.powersite
From: "Larry Cermak [Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: SetColumnLink - Error with multiple parameters
Date: Thu, 22 Feb 2001 22:09:11 -0700
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: node-64-248-206-25.dslspeed.zyan.com 64.248.206.25
Message-ID: <382_p5OBkDVnAHA.199@forums.sybase.com>
References: <382_27A5A4090E26B10800557D9B852569FA.00557D92852569FA@webforums> <382_2YyRaOInAHA.161@forums.sybase.com> <382_E7A9CF4162F6CA38004B5A50852569FB.0016E78A852569FB@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powersite:270
Article PK: 840529

Please send my a private email since advertising is against newsgroup
policy. I'll send you the information.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc
EAServer Consulting and Training

Now Available: The Web DataWindow eBook

Web DataWindow Articles: http://my.sybase.com/detail?id=1003371

<lichn> wrote in message
news:E7A9CF4162F6CA38004B5A50852569FB.0016E78A852569FB@webforums...
> Thanks, I made so many changes to try and fix it. Tell me where can "The
> Web DataWindow eBook" be purchased?