Posts by dickersonka

lol easiest way to explain it is be specific

from table1, table2 join table3 on id = table3.id

who knows what that means

now this

from table1 inner join table2 on table1.id = table2.id 
inner join table 3 on table3.id = table2.id

looks much clearer at least to me

you need to add a group by

GROUP BY cust_no,......

well show us what you got

first, can you open one image? and what are you opening images with?

your code will help out

here i found an article on the suggestion i gave you earlier

its because order of precedence, also always try to do joins this way, makes much cleaner code

http://damonparker.org/blog/2006/02/23/mysql5-join-syntax-changes/

just a normal insert will work

what are you inserting from?

you would just need to add it as a reference in the project

what specific piece are you having trouble with?

yes you did, now hopefully he will go down that path

select db_name()

you did not post the error

you first post was close, you just needed to make your for loop call the second method, if true add it to the list, if false don't do anything

I can't say for sure if it would be or not. The main part of the slowdown is accessing an external network through the internet, rather than it being just on a different computer in the same network. The hosting sites that offer separated web and database servers are on the same ntework. This allows the web server to just use its resources on hosting pages and db server for just doing db operations. I would go as far as to say as almost always when a plan is sold with web and database, the servers are on the same internal network which the speed would be very fast.

well what are you having trouble with then?

you told us what you need to do, and you said you could program it, so if you need help with something specific, let us know

sure thing man, finally got up to veteran poster now along the way :-)

glad it all works for you, and i'm sure you understand relational databases much better

TORONTO here i come!!!

actually no need to check the uas table at all, just delete, then insert

you are correct, check user table i guess from a login or whatever that is, then no need to check anything against uas table except when displaying the form, on submit delete and insert

also i normally wouldn't suggest this, but i think it is appropriate here, we don't need a uas_id on uas table, it is always being deleted and never referenced, you can keep it, no big deal, its just not of use i see yet, but maybe keep it if you think you will need it later

no need to do a check, just run the delete, it won't matter if there is a match or isn't

then just run inserts

nice job man, much more rewarding when you find out how to do it, than when we just tell you

constraints will do what you are meaning, delete from the user table then it will propagate to other tables that reference that user

lol did i put delete *, just use delete from without the *

well it doesn't make sense as far as the user won't have any services, from the database side it just means there is a user, just no services saved yet

yes users -> uas 1..x

it means a user has been created, but no services have been created

well show us what you have worked on, we won't do it for you, only help you

should be the opposite, user_id can't exist in the uas table without being in the user_table

delete from the uas table only, not user table

try to run the command without php and see if you get any errors

noooo, not the user table

this is what i was meaning, i think you are using $u_id

delete * from useraccessservices where user_id = $u_id

maintain the user table, how do you get to the screen where you update your services? have to log in or anything? you should know a user id if you are loading fields based upon it

ahhhh, well we have no deletes here

i don't really like this option, but would you want to delete all the rows for that user_id prior to doing updates and inserts?

(edit: stupid me, there will be no updates if the rows are deleted :-) )

bootloader is traditionally a piece of software

this should help you out
http://en.wikipedia.org/wiki/Booting

is it ie6 with sp3? or pre sp3?

is this an email or webpage?

i can help you yes, one thing at a time

does your prime number one work now?

here's an example you can use for help with serialization

http://www.osix.net/modules/article/?id=692

agree with lizr, i don't know why the need to send it udp

if you truly need a network based simulation, rather than same computer simulation, i would suggest using a webservice

let me give you some tips, you are making progress though

you can't use a for loop like that because the number entered is not a number you go up to, its the total number or prime numbers, redo it with a while loop and a counter for primes found

here's enough to get you started

int num = Int32.Parse(Console.ReadLine());
int primesFound = 0;
int curNum =2;
while(primesFound < num)
{
   bool isNotPrime = false;
   
   //do your check for prime against curNum

   if(isNotPrime == false)
  {
 //if curNum is prime number, print it...
      Console.Write("{0} ", curNum);       
// increment our prime counter
primesFound++; 
  }


  curNum++;

}

would love to help, but please post the code in code tags [ not <

i will help you, but you must try first

maybe try google, c# is prime

first n, needs to be an integer

second, you need to see if its a prime number, dividing by two doesn't work (ex 9)

sounds like homework to me

why don't you give it a shot and we'll help you out

here's a link that should help

http://www.bobpowell.net/grayscale.htm

here's a simple example, probably overkill for what you need

http://www.c-sharpcorner.com/UploadFile/mahesh/ReadWriteXMLTutMellli2111282005041517AM/ReadWriteXMLTutMellli21.aspx

you need to implement ISerializable

ahhh that one is a tad bit different

here's someone with the same problem on expert's exhange
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_20639755.html

here's a quote from the following link that may be of interest

The key issue for developers is what is actually trusted: It's the Outlook.Application object that is passed by the add-in architecture. Therefore, in order to avoid Outlook object model security prompts, the add-in must derive all Outlook objects from this Outlook.Application object. In VSTO add-ins (Visual Studio 2008 and VSTO 2005 SE), that would be the Globals.ThisAddin.Application object. In shared add-ins using the IDTExtensibility2 interface, that would be the Application object passed as an argument by the OnConnection event.

http://www.outlookcode.com/article.aspx?ID=52

you can specify sql user accounts and ip addresses if need be

why do you need the extra table?

why don't you just query from occurences, the same one that you populated reminder with?

print the query right before its executed once values are subbed in, need to see what is happening here

i don't think speed is necessarily going to be an issue, just be sure to make fk and primary keys, and indexes where necessary and you should be good using a single db

on top of that, it would be a nightmare for multiple databases, multiple upgrade scripts, i would most likely advise against it unless its truly a distributed application

i believe when you are creating the controls dynamically like that, the control is not there that signaled the event

http://gregmckinley.com/cs/blog/archive/2006/09/29/27.aspx

there will be an entry in the array for each service for that user, the part i'm not sure about is how are you having duplicate id's?
40
40
40?

42
42
42?

are you sure the user that you are impersonating has permissions to the mapped drives?

try logging in as that user and seeing if the mapped drives exist

not sure why they changed it

you don't see related features on the right? with aspnet code snippets?

you can also use mysql_num_rows to the same effect
http://us.php.net/mysql_num_rows

thats it man

the reason why you have to query all three for the uas, is because user_id has multiple airports and multiple services for each, without a uas_id then you need to query against all those

sorry about that, all you need to do see if there is a result or not

here's a link if you are ever interested
http://pear.activeventure.com/package/package.database.db.db-common.getone.html

they are on the right hand top side, much different layout though, not sure if i am up for it

here's a link as well
http://www.daniweb.com/code/

thanks for the reference ddanbe :-)
just so happened to coincide with me posting