Posts by dickersonka

show us your code and we can help you out

what is the code for your insert statement? also are you sure you are needing an insert statement here, or an update

i'm assuming you are using windows forms

here's some links
http://www.codeguru.com/csharp/csharp/cs_controls/treeview/article.php/c15373/

if asp.net
http://www.keirgordon.com/2007/09/multiple-selection-dropdown-for-aspnet.html

did you read my above post with how to fix it in the registry? you can easily do that with c#

why not use a listview? or checkbox group?

ah hah, forgot to look at the previous post, i've had some trouble, normally not, but sometimes yes, just want to try and eliminate all possibilities

Its a definite plus that you enjoy programming, or at least the lighter side of it. And the end user experience is definitely good as well. Coding full time is much different than just every now again, I love to program, but some days I still need a break.

Find out if you really like programming enough to do it all day, take a course or two and maybe buy a book. There are so many areas to go into, but since you have VBA experience, possibly start with VB.NET or C#.

Take a full weekend day and program the whole day. See if you really could enjoy it the whole day compared to every now and again, check out the learning curve for you. Any other questions feel free.

and also just to make sure you aren't running client and server on the same machine are you?

lol i've been looking at numbers all day, but yes the array looks good

wow, going the static route, i would suggest any time you have, make it a dynamic page, it will make your life much easier if things ever get changed, rather than trying to remember positions in the array, also it will actually be less code on you, but i know how time contraints go

hope you can knock this out in just a little bit :-)

sorry to bombard you with links, but here is another server example

http://fragments.turtlemeat.com/javawebserver.php

sorry don't have time to debug it right now,
are you getting an ioexception in the server from the first trycatch?

For the main search, once that search is preformed it will check against the part2model table for matching part_2_model id's where model_id is equal to the part_2model id.

no it will check against the model id's, you have the model_id
part_to_model_id is just a key for this table, you don't necessarily need it, i think its just best to have a pk for each table

And finally the parts table that would hold a part2model_id that would bring back all results within that table that matched the part_2_model id?

parts table will hold a part id

the parts2model table related what parts, belong to which mode/edition

you will query against part2models, you will know the model (model_id) and part (part_id) and possibly edition (edition_id)

nm, think i was thinking of something else

can you please post the server and client code, at least the guts part where its sending and receiving

i don't think it will return null, until the socket gets closed

not for sure if this is the terminator, but did you check for "." (period) with crlf?

also check -1

ahhh i see now, i know you may not like the idea, but just name the checkboxes as groups when you are displaying them, on postback only grab the ones for the selected airport (also for each airport)

<input type="checkbox" name="YVR[]" />
<intput type="checkbox" name="YYC[]" />

ahhh, see a lot of the same part available to multiple editions of the same model and of different years

i would suggest creating a part2models table

part2models
PART_TO_MODEL_ID
PART_ID
MODEL_ID
EDITION_ID

you can use your parts table you had

make sure you add a year_id to the models table, and edition table for the model

edition
EDITION_ID
MODEL_ID
EDITION_NAME

i'm not sure how vehicles parts necessarily work, but if they "share parts" ie one part works in multiple models then yes you need a model_id and make_id, if they don't share parts, you need only a model_id, and also remember you will need a year_id because i doubt all parts will work across years

do you have a sample row of the excel file? that may give a more clear understanding to the relationship

you will need to parse out the "(#)" because you have the rest of the string to deal with, it is going to make your order by pretty messy, you sure you aren't able to separate (1) into a column?

he said the 6 highest salaries, if you do an asc sort, you will get the 6 lowest salaries, not highest

yes you could, but i would normally stick with a normalized structure like this

you need the foreign keys, a model is tied to a make

vehiclemodel
VEHICLE_MODEL_ID
MAKE_ID
VEHICLE_MODEL

do you understand what i mean that way?

that allows a model to correspond to a make, and spec correspond to model, and product to model

you have your for loop commented out

for startes make these changes

int n;

n=input.nextInt();

for(int i=0; i<= n; i++){
//do your println's here using i instead of n
//if you need a double from an int use
(double)i;
}

maybe i'm more of an ide guy than command line, but for the editor, you just need to add a class and click Build - Build Solution and voila!!!!

i've heard of it, but never used it Portos

http://www.cs.cornell.edu/People/egs/portos/

post your code, its hard to see what you are having trouble with

here is how to do the fix in the registry

http://sogeeky.blogspot.com/2007/04/how-to-disable-outlook-security-warning.html

sorry that one did require a license key, is that the message you are referring to though?

this should help you out

http://www.add-in-express.com/docs/outlook-security-manager-addins.php

you need to either register the event after databinding or set a boolean to check when finished loading

this might help
http://www.vbforums.com/showthread.php?t=207065

public boolean isEmply(){
if(top == -1){
   return true;
} else {
  return false;
}
}

public boolean isFull(){
 if((stackSize - 1)  == top){
  return true;
}
else {
  return false;
}
}

also change your push to use top++

think this link should help you out

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic2741.aspx

normally you wouldn't store the sum of all the payments together like this

normally you have a total and payments

total
TOTAL_ID
TOTAL_AMOUNT

payments
PAYMENT_ID
TOTAL_ID
PAYMENT_AMOUNT

you might need to add users into this, but you normally don't want a column to be updated from the sum constantly, calculate each time you do a select

what is the actual sql query? i see a sqlgrouponly and sql ext, but don't know which is used

also what is this (1)? is that a gallery name, group, or what?

do your textboxes have a default value of "mala" and "123"?

are you sure the extensions installed properly on the server?

also restart iis after that, and make sure you public key token is in caps, for some reason i have saw that make a difference

actually it needs to be descending or else you will get bottom to top

select top 6 * from table_name order by salary desc

are you wanting dynamic variable names?

if so you can't do that in java
you can use an ArrayList or HashMap to store a name and a class

String userSpecifiedName = "SunServer";
HashMap<String, Simple> map = new HashMap<String, Simple>();

Simple simpleClass = new Simple();
map.put(userSpecifiedName, simpleClass);

sorry, forgot it was java, here's a sample java tcplistener

http://www.koders.com/java/fid857615100E60AA30093DF6D87C3135D7AE75C4F5.aspx

here ya go, just needs slight modification on response and your listening ports

http://www.codeproject.com/KB/IP/tcpclientserver.aspx

and maybe if i don't understand properly, let me know what services are being inserted that are wrong, what isn't being inserted my above post isn't correct

i think maybe its a misunderstanding of the table

the table is for services that the user has per airport, which is whats its doing

the services that aren't checked don't go in the table

when trying to find what services a user has for an airport use

select * from userairportservics where user_id = ? and airport_id = ?

then you can loop through the results and see what services the user has at the specific airport, if the service isn't in the list, they don't have the service available

no you must create your own validation code

think of it this way, what happens if you change the length of your field in the db, how can the code know

you can either check it code side, or create a stored procedure that will check the length along with the insert

cursor is related to looping through a result set

a cursor is best thought of as a foreach loop for sql, you can loop through either a temp table or an actualy table

are you sure are checking if the checkbox is checked before adding it to the insert list?

if you need some help post your schema and what the timestamp requirements are

i don't understand what you can't do, you can check the length, but there isn't something to throw an exception from the runtime automatically

you want to test the parameter? like pFirstName?

also when inserting, rather than messing with sqlchars class, i would just use a string

you don't have to, it will automatically trim it

or lets see you get a string field that you are going to insert, with max length of 5

string fName = "jonathan";

if(fName.length > 5)
{
//you can handle what to do with the length here
//we can trim it, throw an error, or whatever else
}

//create command text with our parameter
mSqlCommand.CommandText = @"INSERT INTO table (FIRST_NAME) values " + fName;

yeh thats what i'll do, just trying to see if there was some trickery that i had forgot

thanks jugortha

in your method for testing you are updating the pb, anywhere you are updating it just call

UpdatePb();

I'm not going to do it this way, i just need a quick app put together

i have a testing application that is loading an xml file that has conditional operators in it

<Variable>numIterations</Value>
<Condition> < </Condition>
<LimitNum>10</LimitNum>

rather than doing a switch on the condition string, i wondered if it was possible to use something like i stated up above