473,236 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,236 software developers and data experts.

Variables being set to GENERAL

Hi,

I've got an old perl program running on my webserver - so old that I
haven't used a perl programmer in about two years :) (we've gone all php
for a variety of reasons). Anyway, I'm stumbling on a problem that I am
almost certain is a problem with my inputs to the script. The program
has a debug mode that is giving me some very weird results.

Here's what the script does: It takes a spreadsheet like this:
Column1 Column2 Column3
val1 val2 val3
val4 val5 val6

and then one at a time (one per row) builds a url like this:
http://www.somedomain.com/anotherscr...2&Column3=val3
(i.e. it builds a GET statement with name-value pairs, where name=column
heading and value=value from the cell)

All is well - except I have one spreadsheet where I end up with a bunch
of the values not equalling what is in the spreadsheet, but instead
being set to 'GENERAL'. It seems it hits a specific column, and every
value after that column, for all rows, is set to GENERAL, for all rows.
i.e.
http://www.somedomain.com/anotherscr...olumn3=GENERAL

As I said, I'm sure the problem is something bizarre in the inputs, like
a space we're not checking for or something - but the GENERAL value I'm
hoping will tell me where to look.

I don't see the word 'GENERAL' in the script anywhere :). Here's the
includes from the top of the script:
use strict;
use CGI;
use CGI::Carp 'fatalsToBrowser';
use Spreadsheet::ParseExcel;
use Spreadsheet::WriteExcel::Big;
use LWP::Simple;
use MIME::Lite;

Anyone care to wager a guess or give me a shove in the right direction
as to what might be causing the script to set a value to 'GENERAL'? I
suspect one of the libraries is kicking out the 'GENERAL', but don't
know enough to venture a guess as to which one, or under what conditions.

Thanks!
Jul 19 '05 #1
1 3211
In article <42******@news.sentex.net>, gcook <gl***@glenn.ca> wrote:
Hi,

I've got an old perl program running on my webserver - so old that I
haven't used a perl programmer in about two years :) (we've gone all php
for a variety of reasons). Anyway, I'm stumbling on a problem that I am
almost certain is a problem with my inputs to the script. The program
has a debug mode that is giving me some very weird results.

Here's what the script does: It takes a spreadsheet like this:
Column1 Column2 Column3
val1 val2 val3
val4 val5 val6

and then one at a time (one per row) builds a url like this:
http://www.somedomain.com/anotherscr...2&Column3=val3
(i.e. it builds a GET statement with name-value pairs, where name=column
heading and value=value from the cell)

All is well - except I have one spreadsheet where I end up with a bunch
of the values not equalling what is in the spreadsheet, but instead
being set to 'GENERAL'. It seems it hits a specific column, and every
value after that column, for all rows, is set to GENERAL, for all rows.
i.e.

http://www.somedomain.com/anotherscr...&Column3=GENER
AL

As I said, I'm sure the problem is something bizarre in the inputs, like
a space we're not checking for or something - but the GENERAL value I'm
hoping will tell me where to look.

I don't see the word 'GENERAL' in the script anywhere :). Here's the
includes from the top of the script:
use strict;
use CGI;
use CGI::Carp 'fatalsToBrowser';
use Spreadsheet::ParseExcel;
use Spreadsheet::WriteExcel::Big;
use LWP::Simple;
use MIME::Lite;

Anyone care to wager a guess or give me a shove in the right direction
as to what might be causing the script to set a value to 'GENERAL'? I
suspect one of the libraries is kicking out the 'GENERAL', but don't
know enough to venture a guess as to which one, or under what conditions.


GENERAL sounds like an Excel format specification, the default one.
Perhaps your program is reading cell format specifications where it is
expecting cell contents. Unfortunately, I have not used the
Spreadsheet::ParseExcel module, but I would look at the code that
fetches the cell contents from the spreadsheet. I couldn't find the
string 'GENERAL' in the Spreadsheet modules, and none of the others are
likely to be the cause of your problem.

If you can't figure it out, then you should post a short-as-possible
program that illustrates the problem. Unfortunately, your problem
depends upon your spreadsheet, which is difficult to post.

This newsgroup is defunct. You should post on comp.lang.perl.misc for
general Perl questions and on comp.lang.perl.modules for problems with
modules, such as you seem to be having. Please read the guidelines for
posting on those groups before posting, however, as it can make a big
difference in the quality of help you will receive.
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Larry L | last post by:
I have a Module that declares several arrays as public, some string, some integers. I then have 2 forms. Form A is the main form, that loads on start-up, and has a command button to open Form B. On...
9
by: Larry Woods | last post by:
I have a site that works fine for days, then suddenly, I start getting ASP 0115 errors with an indication that session variables IN SEPARATE SESSIONS have disappeared! First, for background...
3
by: Max | last post by:
Frankly, i need session variables to persist regardless of load balancing. My hoster says save them in files, yuk. Are there any other thoughts The problem is that the session variables are lost...
3
by: Microsoft | last post by:
I am using Session variables in my ASP application. I have tested the application on a Win2k professional and it works fine. When the same web app is installed on a win2k advanced server from the...
15
by: CR | last post by:
I've noticed that the trend these days is to declare variables in the middle of code instead of at the top. What is the advantage of this? It seems like it makes it hard to reuse variables. Here...
8
by: dwok | last post by:
I have been wondering this for a while now. Suppose I have a class that contains some private member variables. How should I access the variables throughout the class? Should I use properties that...
27
by: Madhav | last post by:
Hi all, I did not understand why do the global vars are initialized to NULL where as the block level variables have random values? I know that the C standard requires this as was mentioned in a...
58
by: Jorge Peixoto de Morais Neto | last post by:
I was reading the code of FFmpeg and it seems that they use malloc just too much. The problems and dangers of malloc are widely known. Malloc also has some overhead (although I don't know what is...
20
by: tshad | last post by:
Using VS 2003, I am trying to take a class that I created to create new variable types to handle nulls and track changes to standard variable types. This is for use with database variables. This...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.