here's a re-send of a post of mine that didn't seem to get through:
>>> to convert a sql server table to xml
>> select ... for xml
> Why sure...
No, I meant try that actual code - btw imho the xmladapter idea is better
but this works:
SQLDISCONNECT(0)
CONNSTRING="DRIVER=sql
server;SERVER=MYSERVE
On 5/30/07, Peter Cushing <[EMAIL PROTECTED]> wrote:
> Jean Laeremans wrote:
> > On 5/30/07, Virgil Bierschwale <[EMAIL PROTECTED]> wrote:
> >
> >
> >> Is there worse ways to do it ?
> >> I'm sure there is.
> >>
> >>
> > tsss...another basic error...
> >
> You mean "ARE there worse ways to do it?"
Jean Laeremans wrote:
> On 5/30/07, Virgil Bierschwale <[EMAIL PROTECTED]> wrote:
>
>
>> Is there worse ways to do it ?
>> I'm sure there is.
>>
>>
> tsss...another basic error...
>
You mean "ARE there worse ways to do it?"
It has been simmering nicely all afternoon though :-)
Peter
On 5/30/07, Virgil Bierschwale <[EMAIL PROTECTED]> wrote:
> Is there worse ways to do it ?
> I'm sure there is.
>
tsss...another basic error...
A+
jml
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/p
On Behalf
Of Ed Leafe
Sent: Wednesday, May 30, 2007 10:29 AM
To: ProFox Email List
Subject: Re: VFP to XML
On May 30, 2007, at 11:12 AM, Virgil Bierschwale wrote:
> Folks, this is far from finished, yet you pick it apart like it is in
> production ??
You post code and ask for hel
> Folks, this is far from finished, yet you pick it apart like it is in
> production ??
Only because you insist it works without saying "I changed it and not
it works"...
This profox list creates a repository that is searchable by people on
the internet, and for sample code to be posted and not w
On May 30, 2007, at 11:12 AM, Virgil Bierschwale wrote:
> Folks, this is far from finished, yet you pick it apart like it is in
> production ??
You post code and ask for help. People respond telling you what it
needs. You go off the deep end.
You need a little thicker skin so t
> So a beginner asking for advice from experienced people is insulting ?
> I'd bet your check against mine that a the majority of people on this list
> would disagree with you.
Ever hear of a silent majority? The lack of answers to your simple
questions over the past 1-2 weeks has been telling eno
ttp://www.bierschwale.com
http://www.bierschwalesolutions.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Derek Kalweit
Sent: Wednesday, May 30, 2007 10:08 AM
To: ProFox Email List
Subject: Re: VFP to XML
> Why do you continue to say that it doesn't work.
&
> Why do you continue to say that it doesn't work.
> It does work and it works exactly the way it was designed too.
Why do you keep insisting you created this XML with the code you
posted? You didn't. The code you posted was wrong. You obviously fixed
it afterwards and are unaware that you posted
: ProFox Email List
Subject: RE: VFP to XML
Virgil,
The problem lies in the following line:
response.write("")
The "marker" tag should not be closed (with a ">") before you write the
attributes. Try something like this instead:
while (not oRS.EO
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne av Virgil Bierschwale
Sendt: 30. mai 2007 16:37
Til: 'ProFox Email List'
Emne: RE: VFP to XML
Agreed..
Problem was the example I sent was just that as I was in the process of
making it work.
The actual code is listed here.
You can see
http://www.bierschwalesolutions.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Derek Kalweit
Sent: Wednesday, May 30, 2007 9:50 AM
To: ProFox Email List
Subject: Re: VFP to XML
> So a beginner asking for advice from experienced people is insulting ?
&
& oRS("titledesc") & " ")
response.write("")
oRS.MoveNext()
wend
oRS.close()
oConn.close()
response.write("")
Virgil Bierschwale
http://www.bierschwale.com
http://www.bierschwalesolu
f Derek Kalweit
Sent: Wednesday, May 30, 2007 8:53 AM
To: ProFox Email List
Subject: Re: VFP to XML
> Yep, I've tried it and I use it.
> Yep, the place that I found all info at is located at
> http://www.econym.demon.co.uk/googlemaps/index.htm
Here's his example:
http://w
would be just
text enclosed by the tag. Also, the problem with quotes inside the attribute
values is a valid concern.
Regards,
Eyvind.
-Opprinnelig melding-
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne av Virgil Bierschwale
Sendt: 30. mai 2007 13:37
Til: 'ProFox Email L
> Yep, I've tried it and I use it.
> Yep, the place that I found all info at is located at
> http://www.econym.demon.co.uk/googlemaps/index.htm
Here's his example:
http://www.econym.demon.co.uk/googlemaps/examples/example4.xml
That's different output than your script gives...
> I'm not going t
alesolutions.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Derek Kalweit
Sent: Tuesday, May 29, 2007 9:38 AM
To: ProFox Email List
Subject: Re: VFP to XML
> As for this not working, have you tried it ?
> I'm sure that you will find that it creat
> As for this not working, have you tried it ?
> I'm sure that you will find that it creates the xml file that google map
> needs exactly and with minor modification, it will create other xml files.
Have **you** tried it? The code you posted creates
elements with text inside it, instead of the xm
Hi Derek
I think I've got it, THANK YOU
Sytze
On 5/30/07, Derek Kalweit <[EMAIL PROTECTED]> wrote:
> > My data looks like this (just 1 line pasted here)
> > stockcode="" chknum="" invnum="28641.00" desc="17" Philips LCD
> > monitor" period="" paidinv="false" ordernum="0.00" ordref=""
> > sperso
> My data looks like this (just 1 line pasted here)
> stockcode="" chknum="" invnum="28641.00" desc="17" Philips LCD
> monitor" period="" paidinv="false" ordernum="0.00" ordref=""
> sperson="1"
>
> I have seen the xml file the client wants and it is a beautifully
> formatted file (It looks like a F
Hi Alan
Thanks for your advice.
I've tried very hard to make this work and I can't see what I'm doing wrong.
I end up with a file that has my data ok, but not in the format that
my client is expecting.
My data looks like this (just 1 line pasted here)
stockcode="" chknum="" invnum="28641.00" desc="
Laeremans
Sent: Tuesday, May 29, 2007 9:34 AM
To: ProFox Email List
Subject: Re: VFP to XML
On 5/29/07, Virgil Bierschwale <[EMAIL PROTECTED]> wrote:
> Information sharing takes place at all levels, whether it be beginning or
> advanced.
For once i agree with you Virgil
A+
jml
[excessiv
On 5/29/07, Virgil Bierschwale <[EMAIL PROTECTED]> wrote:
> Information sharing takes place at all levels, whether it be beginning or
> advanced.
For once i agree with you Virgil
A+
jml
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
PROTECTED] On Behalf
Of Derek Kalweit
Sent: Tuesday, May 29, 2007 9:15 AM
To: ProFox Email List
Subject: Re: VFP to XML
> response.write("")
> response.write("")
> while (not oRS.EOF)
> response.write("")
> response.write("lat=&
> response.write("")
> response.write("")
> while (not oRS.EOF)
> response.write("")
> response.write("lat=" & oRS("svclatitude") & " ")
> response.write("lng=" & oRS("svclongitude") & " ")
> response.write("html=" & oRS("htmldesc") & " ")
> response.write("l
You can use the XMLAdapter class (VFP 8 and VFP 9)
local oXML,cXML
oXML = Createobject("XMLAdapter")
oXML.AddTableSchema('yourcursor')
oXML.ToXML("cXML")
Your cursor is now converted to an XML text file (cXML) that you can pass
as a parameter to another form, with a private data session.
do f
29, 2007 4:24 AM
To: profox@leafe.com
Subject: RE: VFP to XML
> to convert a sql server table to xml
select ... for xml
???
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree Engl
> to convert a sql server table to xml
select ... for xml
???
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it
Don't know if this will help or not, but this is what I used yesterday to
convert a sql server table to xml
Still haven't figured out how to save it as a text file on the server yet
though
Just take out the response.write and use the foxpro command, something like
fput I believe.
qry = "SELECT s
Sytze de Boer wrote:
> Hi Foxers
> This is completely new territory for me and I hope someone can help
>
> Client has given a XSL file and an XML file
> The XSL file is referred to as a schema file
>
> How can I convert a small dbf file to XML file ?
> Do I need the XSL file to do this ?
>
Look
31 matches
Mail list logo