you need to have an open connection, just as it says, right before you call execute reader call this


if (conn1.State != ConnectionState.Open)
{
conn1.Open();
}

...

you are trying to run the jar file

do you have this in there?


public static void main(String [] args)


i'm assuming you don't, but for a jar file to be run, just like any other code, it...

its because you are using an untyped list for one, but you didn't have an else statement


if (yourValue == "b")
{
break;
}
else
{
numbers.Add(Convert.ToInt32(yourValue));

there are other ways you could do this, but here's one


select
CAST(Reference AS INT) as REFERENCE
from tablename

you don't always have to use that way, but you can

you could also do something like this


foreach(int num in numbers)
{
Console.WriteLine(" " + num);
}

this will loop through all the values in your array
IEnumerator basically means you can use it to iterate your data

lets say you have 1, 5, 3, 8 in your array

this will print out

1 5 3 8

also try this statement also


select * FROM assign2 WHERE UPPER(CONVERT(keyword1 USING latin1)) LIKE '%MICROSOFT%';

What type of collation is this?

run this


SHOW FULL COLUMNS FROM assign2;

Awesome, you happen to know what the issue was with the one we were working with?

the stop table is only used in the subquery and can't be referenced outside of it

i don't get why, but it looks like the isdrop =1 is not just joining on those records

try adding this piece in...

its not late, only 5, just got a few left before work is done though, there is some data in here that isn't jiving

this will do a partial update, but might help determine what is going on

add...

so close, just something in there i'm just not catching right now, one last try for the evening, cross our fingers


UPDATE jobhistory
SET modifieddt =
(SELECT top 1...

but all stop.stopcompletiondatetime are not null?

hmmmm,

run this


select jobhistory.histjobid, stop.stopcompletiondatetime
from jobhistory
inner join jobxstop
on jobxstop.jobid = jobhistory.histjobid
inner join stop

sorry long day already, i didn't have the join on the original table, lets go back to your query the first time with that one line removed


UPDATE jobhistory
SET modifieddt =...

i can't completely tell the structure, but i believe this will work, just make sure you do a backup first!!!


UPDATE jobhistory
SET modifieddt =
(SELECT stop.stopcompletiondatetime
from...

you have this in here
INNER
JOIN stop
ON stop.stopcompletiondatetime = jobhistory.modifieddt

which will not work, because stopcompletiondatetime does not equal your modifieddt

The exe is the compiled solution, all exes have already been compiled as well

if you are in a winforms app, it needs to be compiled before running it, if you are in asp.net you can set the project...

In the past I have used SharpZipLib

http://www.icsharpcode.net/OpenSource/SharpZipLib/

select p.ID,
(SELECT SUM(i.IncomeAmount) from Income i where i.PersonId = p.ID) AS INCOME_AMOUNT,
(SELECT SUM(o.OutcomeAmount) from Outcome o where o.PersonId = p.ID) AS OUTCOME_AMOUNT
from Person...

select top 3 *
from tableName
order by col3 desc

System.Diagnostics.Process.Start("calc")

Ok, just wanted to make sure we aren't chasing a ghost

Rather than just adding the parameters with a name and value, try to add them with a name and type

SqlParameter param1 = new...

this doesn't have error handling, but here is how you do it following your line


$result = $mysqli->query($queryStr);

$row_count = $result->num_rows;

$result->close();

For starters lets start off with syntax:

Did you see this line?
SqlParameter("@ResultTime", ddRTime.Text.Trim()));

your parameter is named @RTime

Are you sure you set the column's data type to datetime? It sounds like you are using varchar

Ahhh sorry, forgot you only needed sql server

here's a link that should help
http://www.nigelrivett.net/SQLTsql/RemoveNonNumericCharacters.html

here it is with modification

CREATE FUNCTION...

here is my idea then


select translate('123AB45',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ') from dual;


i don't necessarily know the context...

of course, the same as you would any other property


public int[] LendMoney
{
get{return lendMoney;}
set{lendMoney = value;}
}

would adding a trigger that will format the field to only be characters upon inserts and updates be sufficient?

well lets start with this

what is the connection string?

from the ui we get a filepath


string filePath = this.textBoxPath.value;

//We call our class like this from the ui
BusinessLogic logic = new BusinessLogic(filePath);
logic.Load();

look at my previous post with a subquery just for you javamedia :-)

i'm not against them at all, just meaning don't shy away from the joins, get a understanding of them and use them in combination...

sorry bout that, was a late night and didn't think twice about it

this will work

select
(select count(*) from posts p1 where p1.user_id = u.user_id) as post_count,
u.user_id
from users u...

much more clear now, well if you really will have 50000 records at once or a large number of records, i would use the sql bulk insert

here's a link that should get you started in the right...

you are trying to do an inner join on something that isn't there, all users don't have posts

unlike javamedia, i would suggest trying to use inner or outer joins, at least to me it makes life much...

a couple possible options is dependent on how you are accessing your data

if lets say you are looping through ids and running a select on each id, then that is very inefficient as far as the...

right, then the exception is correct

uri is expected to be a registered prefix, and javascript is not, things are working properly!!!

lol whoa, i thought you said it was microsoft

right, but when that throws an exception, what is the linkItem?