Marketcircle    Forums  Hop To Forum Categories  Extending Daylite  Hop To Forums  Scripting    Extending Fscript Raw SQL Example
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Apprentice
Posted
I reviewed the Get Role types F-Script sample in the documentation but I wish to expand it further.

I've been trying to get more than 1 field from the table and append it to a text file.

Specifically, I'm looking to get contactID, firstname, and lastname from Contacts and write them to a tab delimited file. I realize that the contactID is not NSString but even when I try to expand the RoleType example it doesn't work.

For example,
sql := "Select name, contactPlaysRoleString from RoleType'.

then later I do the string appending with s;

[
obj := (rows objectAtIndex:i).
s appendStringfrowneobj objectForKey:'name').
s appendString:'\t'.
s appendStringfrowneobj objectForKey:'contactPlaysRoleString').

s appendString:'\n'.
i := i + 1.
].

But this doesn't work either, both are type NSString.

Can anybody help?

Thanks!
 
Posts: 20 | Location: San Diego | Registered: April 24, 2008Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

Marketcircle    Forums  Hop To Forum Categories  Extending Daylite  Hop To Forums  Scripting    Extending Fscript Raw SQL Example

© Copyright 2006 Marketcircle Inc. All rights reserved.