more SQL problems

[Frank D. Engel, Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Oops, yeah, I missed the quotes thing in my example here, too:

on mouseUp
   put field "mySearch" into x
   replace "'" with "''" in x
   put revQueryDatabase(dbID, field "CurrSQL" & " '" & x & "'") into q

   if q is not a number then
     answer error "Database Error: " & q
     exit mouseUp
   end if

   revMoveToFirstRecord q
   put revDatabaseColumnNamed(q, "City") into field "myCity"
   put revDatabaseColumnNamed(q, "State") into field "myState"
   put revDatabaseColumnNamed(q, "Zip") into field "myZip"

   revCloseCursor q
end mouseUp


On Dec 29, 2004, at 12:01 PM, Frank D. Engel, Jr. wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> revDataFromQuery does not use the revDatabaseColumnNamed function -- 
> that works quite differently.  You want the revQueryDatabase function 
> instead.
>
> Try this:
>
>
> on mouseUp
>   put revQueryDatabase(dbID, field "CurrSQL" & field "mySearch") into q
>
>   if q is not a number then
>     answer error "Database Error: " & q
>     exit mouseUp
>   end if
>
>   revMoveToFirstRecord q
>   put revDatabaseColumnNamed(q, "City") into field "myCity"
>   put revDatabaseColumnNamed(q, "State") into field "myState"
>   put revDatabaseColumnNamed(q, "Zip") into field "myZip"
>
>   revCloseCursor q
> end mouseUp
>
>
>
> On Dec 29, 2004, at 11:09 AM, docmann wrote:
>
>> Hello folks,
>> I've been trying to resolve a problem on my own off and on for several
>> days and just can't seem to get my head wrapped around it all. Even
>> worse, now with so many attempts and errors under my belt, I have
>> finally reached the point of almost total confusion. :(
>>
>> Let's say that I have a MySQL database named "quickref"
>> The 3 records in my table look something like this:
>> --------------------------
>> |  City  |  State | Zip  | --*City is the primary key
>>
>>   Houston   Texas   74239
>>
>>   Portland  Oregon  32791
>>
>>   Dallas    Texas   75217
>> --------------------------
>>
>> dbID is the ID returned when the connection is established
>>
>> revField1 is named "myCity" --used to display record content
>> revField2 is named "myState" --used to display record content
>> revField3 is named "myZip" --used to display record content
>>
>> revField4 is named "CurrSQL" and contains "SELECT * FROM quickref 
>> WHERE City ="
>> revField5 is named "mySearch" and contains "Portland"
>>
>> I have no problems connecting to the database and returning the dbID
>> and all I want to do is display the contents of a record in each of
>> three fields based on the name of the city entered into the "mySearch"
>> field.
>>
>> RevButton Named "Search"
>> on mouseUp
>>   put field "CurrSQL" into tSQLStringPartOne
>>   put field "mySearch" into tSQLStringPartTwo
>>   put tSQLStringPartOne & " " & tSQLStringPartTwo into tSQLQuery
>>
>>   get revDataFromQuery(,,dbID,tSQLQuery,"tMyResults")
>>
>> end mouseUp
>>
>>
>> I've tried using an almost endless number of
>> "revDatabaseColumnNamed()" combinations trying to extract the data,
>> without luck.  Although there may still be more than one problem in my
>> scripting, I *think* that the issue is in the way I'm trying to use
>> the revDatabaseColumnNamed() function which I don't fully understand.
>>
>> Based on the info shown, can someone please show me how to properly
>> get the record set into variables so I can display them in the
>> appropriate fields on my stack?
>>
>> I'd really appreciate any help or advise.
>>
>> -Doc-
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
> - -----------------------------------------------------------
> Frank D. Engel, Jr.  <fde101 at fjrhome.net>
>
> $ ln -s /usr/share/kjvbible /usr/manual
> $ true | cat /usr/manual | grep "John 3:16"
> John 3:16 For God so loved the world, that he gave his only begotten 
> Son, that whosoever believeth in him should not perish, but have 
> everlasting life.
> $
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.4 (Darwin)
>
> iD8DBQFB0uLY7aqtWrR9cZoRAthgAJ4hamACeIisOOhks6XnsBfGModGWwCeOTbK
> rjPwIeDkPGunNEJwWGIfoBk=
> =WgRs
> -----END PGP SIGNATURE-----
>
>
>
> ___________________________________________________________
> $0 Web Hosting with up to 120MB web space, 1000 MB Transfer
> 10 Personalized POP and Web E-mail Accounts, and much more.
> Signup at www.doteasy.com
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101 at fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB0uVn7aqtWrR9cZoRAoG4AJ95qqKKxS8n/0/OXeqfs6bhDgJ1KACbBEq5
S2emuRSup9tlKSUjFj4gG8I=
=9gqp
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com