Posts by dickersonka

The problem with windows service as LizR has stated is security. Services are started up as different user accounts, than the logged on user, although they can be set with the logged on user. I think you are thinking about the application in the wrong context trying to get it to use a service. Services should require no user interaction whatsoever. You should be able to do the same thing with an actual application that is set to run on startup for the user, not a service.

then use two selects

the first one you have above, the second is the same just change od.cat_id = 9

do an inner join on these on uid and then you will have the uid's that are both 8 and 9

http://dev.mysql.com/downloads/timezones.html

That is the mysql list

use the query from before

SELECT * FROM mysql.time_zone_name;

Nothing to be sorry about, just directing you to the place that will you get more answers.

http://us.php.net/manual/en/timezones.others.php

has a warning at bottom of the page

the continent/cities are deprecated, you need to use country with them

you can see the time zone info's here
http://www.timezoneconverter.com/cgi-bin/zoneinfo.tzc

Little hard to read through the translation. I would say to add a node or attribute to your xml document that you read in that sets a variable of whether to display it or not.

This really isn't a database question, I would suggest moving it to the correct forum for a little more assistance.

America/Buenos_Aires is deprecated. Still works, but the full continent/country/city is the new calling convention.

Same thing for the other category, it is deprecated but still exists just for backwards compatibility.

Use the new calling convention of Continent/Country/City to ensure compatibility for future releases

I have it, its a pretty descent small book. Here's also a couple links that might be of reference

http://www.comp.lancs.ac.uk/~ss/java2c/diffs.html

http://www.d.umn.edu/~gshute/java/c2java.html

sorry i misread the original, it is BOTH "degree" (not degrees) and scale

public Degree(float degree, char scale)
{
   this.scale = scale; 
   this.degree = degree;
setDegrees(this.degree); 
  }

the conversion is taking place in the setter, which is always called on each constructor, the getters only need to return the value

Lol thanks. It was good with the last version of firefox and never tried opera. Thanks for your foresight.

I'll second ddanbe.

I will always name my textboxes prefixed with tb
example: tbSendText

the actual constructor signature is fine, the code inside is not

public Degree()
  {
this.scale = 'C';
this.degree = 0;
setDegrees(this.degree);
  }

 public Degree(float degree)
  {
this.scale = 'C';
   this.degree = degree;
setDegrees(this.degree);
  }

 public Degree(char scale)
  {
    this.scale = scale;
this.degree = 0;
setDegrees(this.degree);
  }

Along with all the previous, you MUST know where the file will be, whether that is remote or local. If it is remote you can use a unc path like \\192.168.1.100\shared\myfile.txt. A possibly better solution would be to use mapped network drives, and not necessarily hard code all these paths. If its on a remote machine you can access it like Z:\myfile.txt as long as Z is mapped to \\192.168.1.100\shared\

You can't have the multiple returns in your toString.

public String toString()
  {
if(scale == 'F'){
   return "Fahrenheit Temperature: " + fahrenheitTemp;
}
else {
	return "Celsius Temperature: " + celsiusTemp;
}
 }

I'm assuming sendText is a textbox.

You need to get the text not the textbox

sendText.Text

In the form properties set formborderstyle to fixed(there are a few fixed types) and you might want to set controlbox to false as well.

You can do it in the registry, not necessarily programmatically like you might want, but here is the link.

http://www.experts-exchange.com/Programming/Languages/CPP/Q_20794497.html

As long as you are on mysql 5 you can do it that, and pretty sure in 4 as well. Just ensure the zone table is out there with entries.

SELECT COUNT(*) FROM mysql.time_zone_name;

The reason why I would say to do it in the app code is that you always know your datetimes are coming across as utc, and not already timezone formatted. It is one of those things you can go either way on, but from experience I have found it most consistent to let the database simply store and retrieve the data, and reside your formatting (timezone and dst in this instance) in the app code.

You have two of the same constructors

Change this

public Degree(float degree)
{
 temp = degree;
 scale = 'C';

}
 
public Degree(float degree)
{
 temp = degree;
 scale = 'F';

}

Read what you are assigned

"Four constructors: one for the number of degrees, one for the scale, one for both degrees and the scale, and one default constructor. For each of these constructors, assume zero degrees if no value is specified and Celsius if no scale is given."

Here are the constructors, read your instructions on what to do with them

public Degree(){
}

public Degree(float degree){
}

public Degree(char scale){
}

public Degree(float cDegree, float fDegree, char scale){
}

Not sure if this what you are asking, but you'll need this at the top of the method signature

public boolean handleEvent(Event event) throws IOException {

}

I would suggest not to use convert_tz in mysql, do it in your application code.

UTC is not subject to time zones or dst. When you get your utc value to the application code, apply your timezone and your dst at that time.

Not sure what language you are using on code side, here is how to do everything in php
http://whatstheplot.com/blog/2008/03/13/dealing-with-timezones-in-php/

i'm not sure of your table structure but would you be able to achieve it with this at the end

WHERE od.uid = USER_ID AND (od.cat_id = 8 or od.cat_id=9)

select * from (select * from table t1 where t1.column=value) as t2
where t2.column=value

You only need to install workstation components as part of the installation. I don't know what you are meaning the other ones will have problems later, each part of the installation can be completed later by only selecting it with no problems, if thats what you are meaning.

I would suggest to do this in code rather than the database.

Always store your dates in utc and don't worry about the timezone, then in the code do the conversion necessary.

I agree, def not as good visio, but for free, definitely can't complain.

Here's a free one I have used before. Covers a large set of the visio like features.

http://live.gnome.org/Dia

This part

But now, I wish to see these buttons "numericstepper" and "size in the shoes item and never in "bags" or "clothes" items..... I don't know how to do.

You are selecting these from a database I assume, so what tables and columns are you using?

You seem to be making things a little hard. Zero things out to start with, then if their choice is valid increment person, then record their choice, then do your calculations. Also remove your line of

person = choice1+ .... etc

here's the gist of what you need

int choice1 = 0, choice2 = 0, choice3 = 0, choice4 = 0, person = 0;

//Leave original code here

if(choice < 1 || choice  > 5) {
 System.out.print("That was an invalid choice -- enter 1 through 5 only");
choice = keyboard.nextInt();
}
//You can add this and make it easier
else {
//We added a new preson
person++;
//Now we'll add their choice
switch(choice){
case  1:
choice1++;
break;
case 2:
choice2++;
break;
//continue on with others
}

This seems like a homework question to me. How about you give it a shot and show us what you think are some use cases for it and we can elaborate.

how about show us the database schema, and your full sql select statement, and you don't need to post the html code, just the sql code

Do you have indexes on any of these columns?

Also, consider revising to not search based upon text strings, you have the id's right there.

Also what are you trying to select, you trying to select count on distinct textcodes?

I don't get what you are asking, if you said the 2nd query isn't what you are wanting. Are you wanting the highest id's of all the distinct textcodes?

here is a couple more columns than you need, just so you can be clear on the query

SELECT
sysobjects.name AS "TABLE_NAME", 
syscolumns.name AS "COLUMN_NAME", 
systypes.name AS "DATA_TYPE", 
syscolumns.LENGTH AS "LENGTH" 
FROM         
	sysobjects 
INNER JOIN 
	syscolumns ON sysobjects.id = syscolumns.id 
INNER JOIN                      
	systypes ON syscolumns.xtype = systypes.xtype 
WHERE     
(sysobjects.xtype = 'U') and
sysobjects.name = 'MyTableName'
ORDER BY sysobjects.name, syscolumns.colid

substitute your table name in for 'MyTableName'

They can be used for both I suppose, but here is the way I normally think about them.

Think of schema's as groupings of tables. This way, you can always see the tables grouped together by schema that are related. Also you will probably need a common schema for ones that are shared.

I would use roles for the security portion. The roles can then have privileges to multiple schemas, and you can still see the tables regardless of the roles.

In short, schema is good for organization, roles are good for security.

You are connecting the usb side the computer correct? If so, this should be a usb device, not a parallel device. Do you have the drivers for the plotter?

Stored procedure would be faster, it is able to take advantage of data caching. Also there would be no intermediary processing of the sql from the web server side. Also a stored procedure is much more maintainable than code, you don't want to have to recompile your code to change a single part of the query.

As far as time on a php page take a look at this
http://www.phpjabbers.com/measuring-php-page-load-time-php17.html

In the bios, try to see if you can find something about onboard ports. The port might be disabled in the bios. Also in device manager look at the irq's to see if there are any conflicts.

Make sure you have the driver's installed also. Although you are plugging in through usb, it might still need the drivers since it is parallel based.

It is wayyy to complicated to convert a doc to pdf, if you are just wanting to use your own code. I agree with LizR, use a pdf printer. You can use Ghostscript PDF Printer and call through code. I have also used pdf995. The pdf spec is fairly complicated and isn't something that you can just code in a short amount of time.

The issue is because you are placing the constraints on the same table

Think of it this way, if you remove a trip in the middle of the sequence, it will cause all other trips that are fk'd from it to be deleted as well

do as the error message tells you and on your fk's instead of on delete cacsade, set to on delete no action

what is the query on the page

Distributor_Film_Information_Form.php

What is your query?

Try executing the same query in query browser and you will have the same result as the webpage.

if you are doing it in code, make the method accept an enum value

if you can do that, agree with lizr and validate what is passed in, might want to add an enum value of unknown to your list and use it if an enum isn't valid for the specified int

not sure what you are calling the code from, but you could either use a stored procedure with aditm passed in or create a view and filter the results based upon aditm

Take a look at this for dynamic variable names with xsl.

http://bytes.com/forum/thread758105.html

you might want to try submitting a sitemap in google analytics

you might not be able to find it with just your name if that word is not one of them that is indexed from your page

take a look at google analytics and it will show you whats going on with it

Read the connection string from a config file, then load the connection string at runtime

to number one and two add the id fields, looks like its vteqbase.eqflxideb

then you can join them from the selects

Are you sure you aren't specifying a height somewhere? Do you have the code you can post?

Whenever you backed up the original database make sure to backup stored procedures, views, and users along with it. Then do the restore and they should be there.