Posts by dickersonka

Agree with LizR.

Books can only go so far. Just like back when you started c++ you had hello world, and i'm sure some loan calculator, and grades calculator.

Do the same thing in c#. You can read code in a book all day, but it necessarily doesn't help, but good for reference.

When you run into a problem, then look at a book or other reference material for an example.

I have gotten Windows Forms to work under mono before.

Are you using any of the winapi as well?

Take a look at the mono migration analyzer, it should most likely tell you what could be wrong.

http://www.mono-project.com/MoMA

what part are you having trouble with?

are the inserts or selects failing?

Normally what you would do is have a single child table, with an additional column for child_type_id

CREATE TABLE ChildType(
CHILD_TYPE_ID int NOT NULL,
CHILD_TYPE_NAME VARCHAR(20),
PRIMARY_KEY(CHILD_TYPE_ID)
);

CREATE TABLE Children(
ChildCode char(3) NOT NULL,
Name varchar(50) NOT NULL,
CHILD_TYPE_ID int NOT NULL REFERENCES ChildType(CHILD_TYPE_ID),
ParentCode char(3) REFERENCES Parent(ParentCode)
PRIMARY KEY (ChildCode)
);

populate ChildType with your 2 entries of what child 1 and 2 are, lets say with CHILD_TYPE_ID's of 1 and 2

this way fk are in place, and if you need to query what would be in the old 'Child2' you can use

-- child 2 query
select * from Children where CHILD_TYPE_ID = 2;

-- child 1 query
select * from Childrean where CHILD_TYPE-ID = 1;

might want take a look at security and see for the sql user you are executing as is able to 'see' the table and modify it

wrap your code with something like this

SET AUTOCOMMIT=0;
START TRANSACTION;

-- do your work here

-- if failed do this
ROLLBACK;
-- if successful do this
COMMIT;

you posted this in the asp forum, but you are asking for sql

how are you wanting to add dates?
you can add dates together, but i don't really know what good that would do for you

be more clear on what you want

if you want to just add days lets say

dateadd(d,1,getdate())

anything in the router error logs?
also anything in the apache error logs?

try typing in the dynamic url with the page, to make sure the page is set up correctly

ie www.mydnsname.com/pagename.jsp

sub jsp with whatever extension you have

look at the router

check to make sure 80 is forwarded for your local ip only, check the router logs when you try to access it

make sure your computer is set to use a static ip also, otherwise on a restart the port 80 might not be mapped properly for the router

also what error are you getting, page not found, denied, or what?

$sel_id = $_POST['sel_id'];

$get_addresses_sql = "SELECT address, city, state, zipcode, type FROM address WHERE master_id ='$sel_id' ";

I use dyndns as well for port 80 with no problems.

Assuming apache is running and nothing else is consuming port 80 like iis, you probably do have a firewall issue.

Turn off windows firewall or whatever you may have.

Also check the router's incoming packets to see if they are being received, to make sure it is configured properly.

you can't have the space after CONCAT_WS and you also need a comma after id

select id , CONCAT_WS(', ', l_name,f_name)

show some effort
you are wanting us to help with a stored procedure of this????

Select * from Test

Agree with pritaeas, definitely use indexes.
Also if you have a lot of records, you probably don't want to use LIKE or 'string%'

take a look at full text searching if the indexes don't straighten up the issue

Should work, but you might want to use this for strings

if you don't care about case use strcasecmp instead strcmp

if equal they will return 0

if(strcmp($email1, $email2)==0){
  echo "Emails are same";
} else {
echo "Emails are Incorrect";
}

Username is already a property of the profile set to readonly, are you trying to add a property or use the current one?

if you need to add a new property, change it to something else like loggedinuser

int openBracket = 0;
int closeBracket = 0;
ArrayList subs = new ArrayList();
//you'll want to use a loop here to check
//if there are no more matches

//gets indexes
openBracket = str.IndexOf("[", openBracket);
closeBracket = str.IndexOf("]", openBracket);

//add substring
//i think you need the + 1 to include the ']'
subs.add(str.substring(openBracket, closeBracket - openBracket + 1));

//resets position
openBracket = closeBracket;

i don't know what isn't working

in your declare for myVAT specify the the length

DECLARE myVAT DECIMAL(4,2)

is the problem a rounding problem? or what doesn't work about it?

what happens you try to run it?

one option if you are dealing with duplicate id's is to create two tables in the same database, then create your queries to select into or update based upon a duplicate id

if you need to filter out empty strings

select * from table where length(column) > 0

filter out nulls

select * from table where column is not null

if you need both, just combine

you could also use a group by for your address criteria

http://office.microsoft.com/en-us/access/HA012314821033.aspx

Here's a sample in c#, hope it will help

http://www.codeproject.com/KB/cpp/wsbarcode.aspx

hmmm, any other print drivers installed? this can definitely interfere

if it won't print try to do this
start -> run -> cmd
net stop spooler
net start spooler

then see if the issue is resolved

Never used it, but here's a link for the java speech recognition

http://java.sun.com/products/java-media/speech/forDevelopers/jsapi-guide/Recognition.html

show what you have then we'll help

Good explanation shanti.

I would also say that null is much easiet to query for than a blank value.

you can do it with a binding source

http://blogs.msdn.com/dchandnani/archive/2005/03/12/394438.aspx

are they completely separate or they both contain the same tables?

might want to take a look at mysqldump and mysqlimport

use a select with a subselect

don't know your columns but you basically need to just issue your query twice and use something like

select * from s, spj, j where s.id in 
(select s.id from s, spj, j where j.city='london') and j.location = 'paris'

i didn't put your joins in there, cause i don't know what j# or s# is, but this is how to do it

Where does myMoney come from???? I think you missed it in the function declaration line

VNC is a good solution

You can set it to where you can connect with no password, or with a password, but only from the person doing the logging in. You can then observe the desktop and interact if need be.

www.realvnc.com

Remote desktop will not allow them to be logged in at the same.

I agree with Teme, I have used IrfanView and it definitely meets all the needs (sizing and color requirements0 for icons.

Not sure if you are wanting open source or not.

Microsoft Office Project actually does a pretty good job of this.

You can use a java editor, there are a couple common ones, eclipse, netbeans.

I suggest eclipse
www.eclipse.org

Did you just reinstall windows or format completely?

If the mbr is messed up that could cause it as well.

When you are formatting, go ahead and do a 'fdisk /mbr'. And do a complete format, not a quick one.

If you are sure everything is seated properly then on the power supply try turning the switch off, press the power on the computer (the computer won't actually turn on), then turn the switch on, then try to turn the comp on.

Check out the bios, to see if the sata device is recognized. Could be quite a few things, but first look there and see if it appears in the standard bios.

DECLARE @inid bigint
declare @outid bigint
DECLARE @hexstring VARCHAR(max)

--set your first value here
set @inid = 437910961
select @hexstring = master.dbo.fn_varbintohexstr(@inid)
select @hexstring = reverse(@hexstring)
select @hexstring = substring(@hexstring, 0, (len(@hexstring) - 9))
select @hexstring = '0x' + @hexstring
declare @binvalue varbinary(max), @hexstring1 varchar(max), @sqlstring nvarchar(max)
SET @sqlstring = 'SELECT @binvalue = ' +  @hexstring
EXEC sp_executesql @sqlstring, N'@binvalue VARBINARY(max) OUTPUT', @binvalue OUTPUT
select @binvalue
select master.dbo.fn_varbintohexstr(@binvalue)
SELECT convert(bigint, @binvalue)

don't believe there is any algorithm for it

you know you have drilled down when you can't have one column changing data based upon another column

ie - classic example
customer
city
state
zip

you could have a zip column with one city and state, then have another city and state with the same zip which would violate it

therefor you would need to create a separate table for holding zip, city, and state

once you have eliminated all occurrences that could happen like this, then normalization is done

sharepoint server is free, microsoft office sharepoint server is not free, its basically for all these additionial feature sets you will have to pay to get

look at the features you need and see if sharepoint services will work for you, or if you do need the full blown moss

you can write webparts for the free version and incorporate probably most of what you are looking for

and if you are looking for totally free, check out dotnetnuke

you can check the box, it just won't show the message anymore, it won't hurt anything

its a good thing and a bad thing

looks like your super anti spyware has worked, and it has removed the files

the problem is, they are set to startup still
remove them by going to
start -> run -> msconfig -> startup

remove the previous, or anything that looks suspicious

might want to run a virus scan just to be safe as well

Show some effort.

Here's a link to get you started
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index

solved then?

my bad, substitute the '+' with '&'

What are your needs for a website?

ASP.NET and Sharepoint are completely different ballgames.

If you are just needing a website, or programmability built in to a website I would suggest asp.net.

If you need a CMS system, many users, ability to change content from users, many companies or sites integrating together, then go with sharepoint. Some parts of sharepoint are free, yet others will cost quite the pretty penny. Its a bit harder to work on as well than your classic site, but just depends on what your needs are.

What does this first project entail?

your total digits on each column is 2

also use columns when inserting

insert into theoritcalHold (TS, TR, ...etc) values(.....)

its cause you have spaces
when creating the query string use this

string qs = "viswa murthy";
Server.UrlEncode(qs);

specify the fields in the insert query

insert into Users (FirstName, LastName, ...etc)

http://www.ehow.com/how_2105212_add-reference-project-visual-basic.html