Weird Part 2
Deane Venske
deane.venske at eduss.com
Thu Feb 12 08:18:52 CST 2004
On Wed, 11 Feb 2004 11:04:27 +0100, Florian Bogeschdorfer <fb at memedia.de>
wrote:
> Sorry, but am I blind to oversee something very elementary?
>
> x=VALselectReturnCursor("SELECT * FROM KUNDENtable WHERE
> vorname=Florian")
> put x
> -- <Xtra child "VCursor" 2 26237d4>
> put VALcursorRecCount(x)
> -- 44
> put getRecordAsPropList(x)
> -- [#mobilnummer: "01732426070", #mobilnummer_ai: 560, #inhouse: 0,
> #allowed: 0, #newDate: "24.01.2003", #lastDate: "12.11.2003",
> #lastInhouse:
> "00.00.2000", #lastActive: "00.00.0000", #flirtID: "", #smsFlirtIDglobal:
> "", #anrede: "Herr", #vorname: "Florian", #vorname_ai: 523, #name:
> "Mott",
> #name_ai: 324, #zusatz: "", #strasse1: "Reinickendorfer Str. 45",
> #strasse1_ai: 1578, #strasse2: "", #plz: "13347", #plz_ai: 258, #ort:
> "Berlin", #ort_ai: 444, #land: "", #geburtsdatum: "15.10.1978",
> #KD_PICpath:
> "", #mixnick: "", #code: "", #Email: "", #telefon: "", #mobilnetz: "",
> #telefonSMStauglich: 0, #fax: "", #geschlecht: 1, #spNr: "", #bdNr: "",
> #zusatz1: "", #zusatz2: "", #zusatz3: "", #zusatz4: "", #zusatz5: "",
> #zusatz6: "", #zusatz7: "", #mailPreferred: "SMS", #KDstatModul1: 0,
> #KDstatModul2: 0, #KDstatModul3: 0, #KDstatModul4: 0, #KDstatModul5: 0,
> #KDstatModul6: 0, #KD_ID: 74, #KD_BUDlistID: 0, #KD_KDG_ID1: "",
> #KD_KDG_ID2: "", #KD_KDG_ID3: "", #KD_KDG_ID4: "", #KD_mailFlag: 1,
> #KD_smsFlag: 1, #KD_briefFlag: 1, #KD_faxFlag: 0, #KD_notiz: "", #KD_BLZ:
> "", #KD_KTO: "", #KD_BankName: "", #KD_Einzugsermaechtigung: 0,
> #KD_KTOinhaber: "", #KD_CC_Inhaber: "", #KD_CC_Nummer: "",
> #KD_CC_Valid_From: "", #KD_CC_Valid_To: "", #KD_CC_CardCompany: "",
> #KD_Ausweisnummer: "", #KD_mobileApproved: 0, #KD_checkedInToday: 0,
> #KD_spare1: "", #KD_spare2: "", #KD_spare3: "", #KD_spare4: 0,
> #KD_GEB_Year:
> 0, #KD_GEB_Count: 0]
>
> put getRecordsAsPropList(x)
> -- []
>
> put getRecordAsPropList(x)
> -- [#mobilnummer: "01732426070", #mobilnummer_ai: 560, #inhouse: 0,
> #allowed: 0, #newDate: "24.01.2003", #lastDate: "12.11.2003",
> #lastInhouse:
> "00.00.2000", #lastActive: "00.00.0000", #flirtID: "", #smsFlirtIDglobal:
> "", #anrede: "Herr", #vorname: "Florian", #vorname_ai: 523, #name:
> "Mott",
> #name_ai: 324, #zusatz: "", #strasse1: "Reinickendorfer Str. 45",
> #strasse1_ai: 1578, #strasse2: "", #plz: "13347", #plz_ai: 258, #ort:
> "Berlin", #ort_ai: 444, #land: "", #geburtsdatum: "15.10.1978",
> #KD_PICpath:
> "", #mixnick: "", #code: "", #Email: "", #telefon: "", #mobilnetz: "",
> #telefonSMStauglich: 0, #fax: "", #geschlecht: 1, #spNr: "", #bdNr: "",
> #zusatz1: "", #zusatz2: "", #zusatz3: "", #zusatz4: "", #zusatz5: "",
> #zusatz6: "", #zusatz7: "", #mailPreferred: "SMS", #KDstatModul1: 0,
> #KDstatModul2: 0, #KDstatModul3: 0, #KDstatModul4: 0, #KDstatModul5: 0,
> #KDstatModul6: 0, #KD_ID: 74, #KD_BUDlistID: 0, #KD_KDG_ID1: "",
> #KD_KDG_ID2: "", #KD_KDG_ID3: "", #KD_KDG_ID4: "", #KD_mailFlag: 1,
> #KD_smsFlag: 1, #KD_briefFlag: 1, #KD_faxFlag: 0, #KD_notiz: "", #KD_BLZ:
> "", #KD_KTO: "", #KD_BankName: "", #KD_Einzugsermaechtigung: 0,
> #KD_KTOinhaber: "", #KD_CC_Inhaber: "", #KD_CC_Nummer: "",
> #KD_CC_Valid_From: "", #KD_CC_Valid_To: "", #KD_CC_CardCompany: "",
> #KD_Ausweisnummer: "", #KD_mobileApproved: 0, #KD_checkedInToday: 0,
> #KD_spare1: "", #KD_spare2: "", #KD_spare3: "", #KD_spare4: 0,
> #KD_GEB_Year:
> 0, #KD_GEB_Count: 0]
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
Hi Florian,
Not sure if you were asking for us to look if there is something simple
wrong here or showing something simple wrong. If you are asking if there
is somethign we can spot then here it is :
In your function that did not work you have made a syntax error:
put getRecordsAsPropList(x)
^
Shouldn't have the "s"
Best wishes!
--
Deane Venske - Senior Programmer
www.eduss.com.au deane.venske at eduss.com
+61 7 55974600 +61 405148718
Suite 29, 207 Currumburra Rd
Ashmore, Queensland, 4214
Australia
More information about the Valentina
mailing list