PeterE
|
Posted: 02/11/2004, 11:43 AM |
|
What is the right syntax for something like this:
SELECT * FROM leads WHERE Dealercode="CCGetUser_ID()"
Need that in my Form Properties SQL string
Using CC, PHP, MySQL. Beginner
PE
|
|
|
peterr
Posts: 5971
|
Posted: 02/11/2004, 1:29 PM |
|
Try using a Table instead of an SQL string. Then in the "Where parameters" section of the Data Source create a parameter like:
Field: Dealercode
Parameter Source: CCGetUser_ID()
Type: Expression
If you need to use SQL then use:
SELECT * FROM leads WHERE Dealercode={User_ID}
and create a parameter:
Field: User_ID
Parameter Source: CCGetUser_ID()
Type: Expression
Default Value: 0
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
PeterE
|
Posted: 02/11/2004, 2:43 PM |
|
But how does that look like in Codecharge (not Studio)?
|
|
|
peterr
Posts: 5971
|
Posted: 02/11/2004, 3:35 PM |
|
Well, in this case I recommend that you submit your question to our CodeCharge forum instead of this one, which is for CodeCharge Studio users.
See: http://forums.codecharge.com/forum.php?forum_id=14
This should prevent confusion and save some time.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
PeterE
|
Posted: 02/13/2004, 8:14 AM |
|
Yeah great, I can wait for weeks in that Forum, it is not very active and I desperately need an answer, so I hoped a more experienced guy would help me out...
|
|
|
peterr
Posts: 5971
|
Posted: 02/13/2004, 1:58 PM |
|
Sorry about this. I thought I was subscribed to that forum but I wasn't. I'll respond in a minute.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|