[wdvltalk] any cgi gurus up and avail to help me out
HI, I'm trying to get a cgi script to work and having problems, any cgi gurus up and available to help out at this hour? Thanks, Deb The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql/php/excel
Hi Melanie, I am not sure. Just try with this. $image = "http://ipbooks.net/pictures/$code.jpg"; S.Elankumaran Software Engineer Applabs India office: 040 3600861 ext:83 Mobile: 9849484354 The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Photo Gallery
That's interesting. You did a beautiful job. Are the images you show in your gallery safe from theft? I like gadgets, especially software 'gadgetry'. So if I find a software program that will do it for me, I get all excited. It looks like you enjoy doing it yourself more. Norma Cooper http://www.geocities.com/brewnetty/CRS130.html http://brewnetty.0catch.com http://www.getrealresults.com Don't be afraid of living ~the alternative is too final. by AuntySpam - Original Message - From: Howard Cheng To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 3:03 PM Subject: [wdvltalk] Re: Photo Gallery Server-side or client-side? The photo album on my own site is server-side PHP, and it's pretty simple to write: http://www.howcheng.com/photos/ Or if you're looking for server-side ASP: http://www.edison.com/media/photo_gallery.asp (I wrote this) Essentially, it's all the same concept. Extract the photo information from the database and dynamically write the table. My site puts the photos in their own page and you can navigate from photo to photo in there. The Edison one simply opens the large image in a popup. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql/php/excel
On Fri, 8 Nov 2002 16:03:59 -0800, Scotty wrote:
>> >The following bit of code is supposed to generate a url in the
last
>> >cell of each row
>> >
>> >
>> >$code= "$row[0]".$sep;
>> > $image=
>> >"http://ipbooks.net/pictures/"."$code".".jpg";;
>> > $schema_insert .= "$image".$sep;
>> >
>
>Try this $image = "http://ipbooks.net/pictures/${code}.jpg";;
>
>The brackets are the other way of interpolating a variable into a
string.
>
Hi Scott
Not too sure what you mean. As written, the line
$image = "http://ipbooks.net/pictures/${code}.jpg";
gives a parse error (I'm using PHP). Also, I can't see where the
concatenation is (or am I being dense?).
regards
Melanie
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: ACCESS & ASP problem
OOPS!
Trying to do too many things at once.
OnItems was your recordset name, so
response.write(OnItems.fields.item("Description").value)
Sorry.
J.R.
-Original Message-
From: J.R. Pitts [mailto:listuser@;wjponline.com]
Sent: Friday, November 08, 2002 10:32 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: ACCESS & ASP problem
If I'm understanding your question properly, you need a where clause.
SELECT Description FROM Items WHERE ItemNumber=2
response.write(Connect.fields.Item("Description").value)
If 2 is stored as number; '2' if as text.
note that
value is the default property of item
item is the default collection of field
and fields is the default collection of a recordset, so
Connect("Description")
will work as a shortcut. But for clarity, and performance (I think) a lot of
people will write it out. The code is probably more portable that way, also.
HTH, Let me know if this wasn't what you were asking.
J.R.
-Original Message-
From: Ingentus [mailto:ingentus@;eircom.net]
Sent: Friday, November 08, 2002 9:56 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] ACCESS & ASP problem
http://www.ingentus.com/access.htm
Hi everyone
I'm having a serious (seriously Stuck!) problem with an Access DB & ASP -
in this case I thought it would be easier explained with a screen shot & a
URL.
If anyone has the time to have a look I'd really appreciate it as always.
TIA
jac.
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: ACCESS & ASP problem
If I'm understanding your question properly, you need a where clause.
SELECT Description FROM Items WHERE ItemNumber=2
response.write(Connect.fields.Item("Description").value)
If 2 is stored as number; '2' if as text.
note that
value is the default property of item
item is the default collection of field
and fields is the default collection of a recordset, so
Connect("Description")
will work as a shortcut. But for clarity, and performance (I think) a lot of
people will write it out. The code is probably more portable that way, also.
HTH, Let me know if this wasn't what you were asking.
J.R.
-Original Message-
From: Ingentus [mailto:ingentus@;eircom.net]
Sent: Friday, November 08, 2002 9:56 PM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] ACCESS & ASP problem
http://www.ingentus.com/access.htm
Hi everyone
I'm having a serious (seriously Stuck!) problem with an Access DB & ASP -
in this case I thought it would be easier explained with a screen shot & a
URL.
If anyone has the time to have a look I'd really appreciate it as always.
TIA
jac.
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] ACCESS & ASP problem
http://www.ingentus.com/access.htm Hi everyone I'm having a serious (seriously Stuck!) problem with an Access DB & ASP - in this case I thought it would be easier explained with a screen shot & a URL. If anyone has the time to have a look I'd really appreciate it as always. TIA jac. The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql/php/excel
> >The following bit of code is supposed to generate a url in the last
> >cell of each row
> >
> >
> > $code= "$row[0]".$sep;
> > $image=
> >"http://ipbooks.net/pictures/"."$code".".jpg";;
> > $schema_insert .= "$image".$sep;
> >
Try this $image = "http://ipbooks.net/pictures/${code}.jpg";;
The brackets are the other way of interpolating a variable into a string.
Scott Anderson
President/Webmaster
http://www.weekendclimber.com
[EMAIL PROTECTED]
@_=map{[$!++,$_^$/]}split$¾,"\@\x7Fy~*kde~box*Zoxf*Bkiaox";$\="\r";
$|=++$*;do{($#,$=)=(rand@_,rand@_);@_[$#,$=]=@_[$=,$#]}for($*..@_);
for$:($|..@_-$|){for($|..@_-$:){@_[$_-$|,$_]=@_[$_=>$_-$*]if$_[$_][
$º]<$_[$_-$*][$Æ];print+map{$_->[$|]}@_;select$
,$,$,0.1}}print$/
-
Introducing NetZero Long Distance
1st month Free!
Sign up today at: www.netzerolongdistance.com
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Photo Gallery
Server-side or client-side? The photo album on my own site is server-side PHP, and it's pretty simple to write: http://www.howcheng.com/photos/ Or if you're looking for server-side ASP: http://www.edison.com/media/photo_gallery.asp (I wrote this) Essentially, it's all the same concept. Extract the photo information from the database and dynamically write the table. My site puts the photos in their own page and you can navigate from photo to photo in there. The Edison one simply opens the large image in a popup. At 03:23 PM 11/8/2002 -0500, Bob Diaz wrote: I know this was discussed a while ago, but either the archive doesn't go back far enough or I don't know how to use it - all I could find was recent things on cheap photo programs ;-) I'm looking for an alternative to a frames page where thumbnails in one frame open the picture in the main frame - any ~~simple~~ suggestions that are cross browser? Bob Diaz :: Howard Cheng http://www.howcheng.com/ <-- NEW! howcheng at ix dot netcom dot com AIM: bennyphoebe ICQ: 47319315 The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Photo Gallery
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 08 November 2002 20:23 Subject: [wdvltalk] Photo Gallery > I know this was discussed a while ago, but either the archive > doesn't go back far enough or I don't know how to use it - all I could > find was recent things on cheap photo programs ;-) > > I'm looking for an alternative to a frames page where thumbnails in > one frame open the picture in the main frame - any ~~simple~~ > suggestions that are cross browser? See what I did with www.artofanderson.com gallery page. The PHP script gets the thumbnail names from a database and lays them out on the page. The links from the thumbnails have an onClick event that opens a small new window containing the larger image, but if JS is disabled they just get opened as a .jpg in a blank new window so it still works, just not quite as well. You could do something like that? Bj The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] mysql/php/excel
Hi all, Finally got the spreadsheet sorted apart from a problem which I cannot solve. I have tried everything I can think of to no avail. The following bit of code is supposed to generate a url in the last cell of each row $code= "$row[0]".$sep; $image= "http://ipbooks.net/pictures/"."$code".".jpg";; $schema_insert .= "$image".$sep; instead the url is split at "$code" and the ".jpg" is placed in the next cell along. The spreadsheet can be run/downloaded at http://ipbooks.net/xls_gen_2.php?w=0 so that you can see what I mean. I need to have this done like 5 hours ago so any help gratefully received. regards Melanie The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: Photo Gallery
Jasc aftershot has an album creator. http://www.jasc.com Gazo is the one I use on my Family Album page (Url below). I tried a couple of others, but find those two the easiest to use. Norma Cooper http://brewnetty.0catch.com http://www.getrealresults.com Don't be afraid of living ~the alternative is too final. by AuntySpam - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 12:23 PM Subject: [wdvltalk] Photo Gallery I know this was discussed a while ago, but either the archive doesn't go back far enough or I don't know how to use it - all I could find was recent things on cheap photo programs ;-) I'm looking for an alternative to a frames page where thumbnails in one frame open the picture in the main frame - any ~~simple~~ suggestions that are cross browser? Bob Diaz The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Photo Gallery
I know this was discussed a while ago, but either the archive doesn't go back far enough or I don't know how to use it - all I could find was recent things on cheap photo programs ;-) I'm looking for an alternative to a frames page where thumbnails in one frame open the picture in the main frame - any ~~simple~~ suggestions that are cross browser? Bob Diaz The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql to excel
On Fri, 08 Nov 2002 10:55:44 -0800, Christina Lannen wrote:
>=CONCATENATE("www.mysite.co/images/", A1,".jpg")
>
>A1 is of course R1C1
Simple when you know how
regards
Melanie
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: multiple messages/question
You can get a free trial version (no time limit, just limit of 500 pages on a site) of Atomz http://www.atomz.com/search/trial_account.htm Never tried it myself, but I've heard a lot about it. Ali Brewnetty (AuntySpam) wrote: Dear list, I've been trying to send a question to the list for 2 days. I keep getting rejected "subscribe" replies too. In case this goes through, I'll ask again. A friend maintains a site offering adaptive products for the disabled. Is there a very simple and easy to use search engine she could install to assist those folks in finding what they are seeking? Norma Cooper http://www.getrealresults.com Don't be afraid of living ~the alternative is too final. by AuntySpam The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: XHTML and input tags
-Original Message- From: rudy [mailto:r937@;interlog.com] > is an inline element and cannot sit naked > > just slap ... around it and all will be well Rudy, I hope the issue is as simple as you describe. I will give your suggestion a try when I get home, but I have to confess that it doesn't seem to make sense to me. The error said there was a block level element inside an inline element. Just the validator getting confused? Thanks, Perry Gerenday www.webinitiative.net The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: XHTML and input tags
-Original Message- From: Mark Groen [mailto:mark@;markgroen.com] > HTML Tidy threw out this one: class="Clearance"> as it's an empty one, and there seems to be > something wrong with the Clearance+Clearleft, etc., can't > put my finger > on it right now Mark, Thanks for taking such a detailed look at my code. I can see why the empty DIVs used to clear the float characteristics might cause some confusion for the validator. They probably looks like something that's been misplaced. > . Just a thought, you've got the flow of the code > reading the right content before the left, maybe there's a div/class > that may show up as the culprit switching them around to read left to > right - btw, shouldn't make a bit of difference though, hmmm. Granted the right to left flow seems odd, but it had to do with the way the right column was acting as a float. I went through several permutations trying to get things to behave correctly. Thanks again, Perry Gerenday www.webinitiative.net The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Post form error in NN 4.7
Hey Folks, I'm hoping someone can shed a little light on a problem I'm having. I've created a php form that feeds over into another php page. It works in NN 6, IE, Opera, but in NN 4.7 this is the message I get on the second page and nothing loads up. Missing Post reply data Data Missing This document resulted from a POST operation and has expired from the cache. If you wish you can repost the form data to recreate the document by pressing the reload button. It does it when you fill in all the items or when you leave them all empty. Anyone run across something similar? Heather Laidlaw Internet Manager Seattle Repertory Theatre [EMAIL PROTECTED] (206) 443-2210 x1044 www.seattlerep.org The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql to excel
=CONCATENATE("www.mysite.co/images/", A1,".jpg")
A1 is of course R1C1
Melanie Phair wrote:
> Hi Scott,
>
> On Fri, 8 Nov 2002 09:13:38 -0800, you wrote:
> >Probably the easiest way to do it is to create an comma delimited
> ASCII
> >file with an extension of '.CSV'. This is a recognized excel
> extension
> >and just double clicking the created file will open it in excel. You
> can
> >use straight SQL to create the comma delimited file, so you can stop
> >quelling over the all the excel modules that you think you might
> need.
> >Try something like this:
> >
> >SELECT your_fields_here INTO OUTFILE 'your_filename.csv' FIELDS
> >TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY
> "\n"
> >FROM your_tables_here WHERE your_where_statements_here
> >
> Great. I was almost there but that got me safely to the destination.
> Thanx
>
> I have another excel question which I will ask here just in case we
> have any excel gurus lurking in the shadows.
>
> Column a contains numeric data, say 100,101,102.etc
>
> In another column I want to put a web link in the form of
>
> www.mysite.co/images/xxx.jpg
>
> where xxx is the value in column a of the respective row.
>
> I guess I need some form of concatenation but I can't figure the
> syntax.
>
> Anyone any ideas ?
>
> regards
>
> melanie
>
> The WDVL Discussion List from WDVL.COM
> To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
>Send Your Posts To: [EMAIL PROTECTED]
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> http://www.wdvl.com ___
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to %%email.unsub%%
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql to excel
Hi Scott, On Fri, 8 Nov 2002 09:13:38 -0800, you wrote: >Probably the easiest way to do it is to create an comma delimited ASCII >file with an extension of '.CSV'. This is a recognized excel extension >and just double clicking the created file will open it in excel. You can >use straight SQL to create the comma delimited file, so you can stop >quelling over the all the excel modules that you think you might need. >Try something like this: > >SELECT your_fields_here INTO OUTFILE 'your_filename.csv' FIELDS >TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" >FROM your_tables_here WHERE your_where_statements_here > Great. I was almost there but that got me safely to the destination. Thanx I have another excel question which I will ask here just in case we have any excel gurus lurking in the shadows. Column a contains numeric data, say 100,101,102.etc In another column I want to put a web link in the form of www.mysite.co/images/xxx.jpg where xxx is the value in column a of the respective row. I guess I need some form of concatenation but I can't figure the syntax. Anyone any ideas ? regards melanie The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] RE: mysql to excel
> You can use straight SQL to create the comma delimited file, > so you can stop quelling... quote of the month ;o) The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED]
