Posts by dickersonka

thanks for the reply, i know i a lot offer cron jobs, i need one that will offer a complete .net environment (non mono) to be able to run an import application with

boxes for what though? what programming language? i understand its an app but what language?

try this

Character.isLetter('1');

if you are asp.net you can use master pages, you can maintain the same layout / navigation for all the pages that inherit from the same masterpage
or ssi (server side includes)

here's link with the pros and cons of frames
http://www.webmasterworld.com/forum21/4794-2-30.htm

gauntlet

here's something i made from another post with the same question

you need to use invokerequired to be able to do this

private delegate void UpdatePbDelegate();
        private void UpdatePb()
        {
            if (this.pbStatus.InvokeRequired)
            {
                UpdatePbDelegate updateCount = new UpdatePbDelegate(this.UpdatePb);
                this.pbStatus.Invoke(updateCount);
            }
            else
            {
                if(this.pbStatus.Value == 100)
		{
			this.pbStatus.Value = 1;
		}
                this.pbStatus.PerformStep();
                this.pbStatus.Refresh();
            }
        }


private void DownloadData()
{
//your code in here that downloads your values
}

private void StartingThread()
{
 Thread t= new Thread(new ThreadStart(DownloadData));
            t.Start();

            while (t.IsAlive)
            {
                UpdatePb();
                System.Threading.Thread.Sleep(50);
            }
}

assuming this is a wireless connection it drops?

possible try updating the driver, and make sure nothing is taking over cpu and network usage at those times

do you have id columns? like vehicle_make_id and vehicle_make?

also model needs to be fk's to make, spec fk'd to model, part fk'd to model i would say, and you prob want a product_category_id

we'll talk about the char after that

well what language are you using and is it web based or application based?

also could you be a little more specific about the problem?

Is it possible to have a dynamic operator? I know I could parse it out and find the symbol just wondered if it was possible.

string aString = "5";
int a = 5;
int b = 6;
string op = "<";

//want to do something like dynamically without checking the value of op
if( a op b)

//want to use the same thing like this
Int32.TryParse(aString, out a);

Operator.TryParse(op, out );

just need to create my own class to do this? or is there somthing i am forgetting

appreciate your help

add an order by date desc and the group by will select the top location

you said dates are chars though?

that is the point of a relational database, to have entities (such as products) grouped with themselves, and their id field be used when they are referenced, that is why you have to build the query to "pull" the description from the id like i gave you

SELECT t1.Description, t2.Category
FROM table2 t2
inner join table1 t1
on t1.ProductId = t2.ProductId

as in you want the fk to be linked to the description?
the query i gave you return the description and category
i'm still not sure what you are needing

here are two links to set up clustering

http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html

http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

a stored procedure is a sql statement that is stored in the database for all queries / tables to be able to have access to (with permissions)

they can return results, update, or whatever you normally do through a query

a temp table is temporary holding place for values, where you can actually select from that table, then it is deleted without affecting your regular database structure

they are normally used in more complicated queries, while stored procedures are used simple such as inserts along with complicated queries as well

select into

is your friend

the disadvantage is its slower, and you can't tell the query being executed until runtime, everything is in a string

it looks like

DECLARE sqls varchar(4000);
SET sqls = CONCAT_WS('SELECT * FROM table WHERE ID=','4');
EXECUTE(sqls);

i'm sure there are some grammar mistakes in there but thats the concept, just messy normally unless you need it

i don't get what you are meaning, you just said you wanted to select from the table without displaying the id

what is a real table?

the reason why you have to use max is the other rows will have null in them, you are able to get all the profile keys with dynamic sql, doubt you want to go that route though

looks good, minus joining on the city, not able to join on an id?

are you sure crs isn't null? where is it getting assigned?

little rough trying to put words into table structure, are you able to post the schema of those affected tables

and just to be clear, you only need dimensions deleted that are not in both tables?

here's a select, just add where u_id = ?

select u_id,
max(if(profile_key='first_name', VALUE, null)) as first_name,
max(if(profile_key='last_name', VALUE, null)) as last_name,
max(if(profile_key='birth_date', VALUE, null)) as birth_date,
max(if(profile_key='etc', VALUE, null)) as birth_date
FROM users_profile
group by u_id;

working on a single select right now rather than a proc, i'll see how much time i have to finish

DELIMITER $$

CREATE PROCEDURE `p_GetUser`(v_U_ID int)
BEGIN

select u_id,
(select value from users_profile where profile_key = 'first_name' and u_id = v_U_ID) as first_name,
(select value from users_profile where profile_key = 'last_name' and u_id = v_U_ID) as last_name,
(select value from users_profile where profile_key = 'birth_date' and u_id = v_U_ID) as birth_date
from users_profile
where
u_id = v_U_ID
group by u_id;
end

are you able to use a stored procedure, or must it be a select only?

you need help with it then? or you are good?

sorry forgot to look at your row structure, give me a few and i'll post back

select p.p_id, post, p.u_id, u.profile_key, u.value
from posts p
inner join users_profile u
on p.u_id = u.u_id

lol but he will fall later rather than sooner

it is giving you the highest id in that table, when you do the insert use

select LAST_INSERT_ID();

this will give you the id of that row, not the highest one in the table

SELECT t1.Description, t2.Category
FROM table2 t2
inner join table1 t1
on t1.ProductId = t2.ProductId

you can do it that way, i would suggest returning a value from a stored procedure like

select LAST_INSERT_ID();

Well one of the best ways is just as it is here. Join in on the forums, many people will make new posts about up and coming or new methods of doing things.

Along with that conferences or seminars might help. I'm sure we all are on some Microsoft or tech e-mail list, take a second and read them sometimes.

Frequent the websites for the software you use, .net take a look at msdn, java take a look at the java site.

lol i think a little over complicating, but you have the right concepts down, just one step at a time

here is pseudo-code, my php is a little rusty right now and i'm sure i would mess it up

$user_id = insert user
foreach airport checked
{
   foreach(servicechecked for airport)
{
     insert userairportservice
     $user_id - from above
     $service_id - checkbox
     $airportid - airport from the loop
}
}

are you sure that is loading your xml file properly?

for testing purposes try to hardcode it, then move it to the xml file

Class.forName("com.mysql.jdbc.Driver");
//continue with the other fields

also, after that if you still get an error, what is it?

different version

set the reference to use specific version

System.out.println(addBuddy(buddyName, server.userList));

sorry not able to confirm this and test your code right now, but try adding validate() before your repaint()

here's a couple articles on major differences between c# and c++

http://msdn.microsoft.com/en-us/magazine/cc301520.aspx

http://andymcm.com/csharpfaq.htm

c++ is still widely used today, probably just as much as c#, but a lot of web apps which is a major trend, are going to either c#, java(jsp) or php

prob the web side of things is the major difference today, no longer just applications, there are applications with a web front end and code behind

you probably want to move this to DBUtil and return a resultset from it

ResultSet rs = pstmt.executeQuery();

also unless its an abstract class with the prepared statement that you manipulate, i wouldn't try to declare in two places, either let it be passed in, or let it be constructed in DBUtil

Definitely. You have experience. I'm in my mid 20's with about 4 1/2 years experience and find myself edged out sometimes by guys that are a little older, with more experience. Bright and motivated is the key, a lot of people just go to work, and yes some can code, but a lot can't code well.

If you primarily used c or c++ originally, then you will prob find yourself fairly accustomed to c#.

Whats your specialty?

Its not necessarily like that. Its a good thing to have, but not a necessity. I am Microsoft Certified, but I don't think it gives me a whole lot of bargaining power. It definitely looks better than not having it, but not better than someone who has more experience and no certs.

very true ddanbe

just gets frustrating when you make post with an answer, and then the original poster doesn't read it and posts back

so friends,, you people facing that problem and dont know the anwer ,..right??.. no one in this forum know the solution???..nobody??

i shall put my sword away

C# and vb but it may be of interest

http://stackoverflow.com/questions/175836/systemwindowsformswebbrowser-open-links-in-same-window-or-new-window-with-same

now its 21, this guy is a joke

i am figuring its because it has ip restrictions to connect to the server from other machines, take a look at the grant syntax

look at step 5
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

that is a major noooo, all good

seems like many people have just run into the same countless problems he has

lol no no, that wasn't me that posted in that forum, i did a good a google search for
Applet RTApplet started

and pretty much every single one was flooded with this sharekahn thing

yes you can do that, but that will probably even be slower, less secure, and just a messy thing to deal with

normally hosting providers will give you access or mysql for a lower price, and then you have to pay a slightly higher price for sql server, are you not able to upgrade your hosting plan?