Posts by dickersonka

A stored procedure is a set of sql code for the database, not a column.

You can find it in the programmability section for the database.

The security on the stored procedure is separate from allowing the login, find the stored procedure going into programmability -> stored procedures for that database

First make sure the stored procedure does exist

Second make sure the user specified in the connection has privileges to use it, if not log in as administrator and allow that user to access it

you can log in through sql management studio as that user after you apply your changes and see if its visible then

Vista is called Vista
Longhorn is Vista, its codename was longhorn and I believe released Vista as its official name before the first beta

typically an xp machine will be slightly faster and the slight few games that have problems on Vista still, should work on XP

I wouldn't say it better than xp, but most issues as far as drivers and compatibility have either been resolved or have a workaround

wrap your contentplaceholders in divs

not without you trying

Not all drivers and software will work. It might be safe to say that most will, but just depends. By now there should be updated drivers for Vista for most products, just check before you update.

could be a couple problems

make sure your dns server is up, also just try to ping the dnsname from another computer

if all that is good, then time to start checking iis

open iis and click on your site, and then check bindings
see if it is listening on the ip hostname, or a dnsname

Might want to try pinging

System.Net.NetworkInformation.Ping

http://msdn.microsoft.com/en-us/library/system.net.networkinformation.ping(VS.80).aspx

use a stored procedure that will accept parameters to insert into a table

It sounds like you are doing inserts manually through code and you will be more subjected to sql injectection attacks

i would create a stored procedure with a cursor

use this to get the table names

SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

and this dynamic sql to set key

exec('alter table ' + @tablename + ' ADD PRIMARY KEY(osd)');

Here's the code I use without any problem when passing byte arrays back and forth from java to c#

//Assign these some values
byte[] byteImage;
string savePath;

FileStream fileStream = new FileStream(savePath, FileMode.Create);
//attempts to write file to local machine
fileStream.Write(byteImage, 0, byteImage.Length);
fileStream.Close();

You do it the same way in vista. File associations are just registry entries in HKEY_CLASSES_ROOT. Here's a codeproject link to help get you started

http://www.codeproject.com/KB/dotnet/System_File_Association.aspx

just run an extra select statement from this query

select sum(quantity) 
from (
-- the above select)
)

check it that way, or here's a gui interface for vista

http://www.creativelement.com/powertools/

you'll want to make sure %1 will be the file

thanks i decided to use overloaded methods

public void addParameter(Long value) {	if(value == null){
//we have a null value
}
else{
//do some stuff here with value
}

I am working on a logger showing showing types and values for classes and sql statements (ie parameters in sql statements)

From the example above I will need to show output as something like
Long: null and BIGINT: null

What is a possible recommendation to be able to do this?

Should I create overloaded methods for each type or pass in the class at runtime? Any other suggestions are welcome and thanks for your help!!!

I am determining what method to call by using the runtime class. My problem is whenever I pass in a null object, obviously it will throw a null reference exception. How are you able to determine at runtime the class of a null object. Although its null i need to do further processing, and woud rather not pass in type as a parameter to the method.

Here's an example

public void test(){
   Long nullLong = null;
   addParameter(nullLong);
}

public void addParameter(Object value) {		
     String parameterType = value.getClass().getName();
//do some stuff here with parameterType
}

show us your query and we will help you

you need to specify what column for the where and the =1 i have no clue what you are wanting there

select * from ( select vRefTable from mainmenu where iMenuId=58 )
where 
-- your column name here
 vFieldsName  in 
(select vFieldsName from TableField where iMenuId=58
and bIsPrimary=1 and iTableFieldId=11)

No

1. Add a do while loop

do{
// your code here

}while(repeat == "y")

2. first part use

int num;
bool isNumber = Int32.TryParse(intput, out num);

if(isNumber)
{
//this means the user input a number
}

the second part

bool isLetter = Char.isLetter(repeat[0]);

Don't think there is necessarily any benefit, just want to make sure it is displaying properly.

I think you are leaving some code out, i see a catch without a try.

Add in some debug code like before streaming the file

also make sure currentFile is a string and not an object

MessageBox.Show("going to open: " + currentFile);

Check for the file existing before trying to stream it as well, you don't necessarily want to rely upon a catch block for logic processing

Regardless of your education you still need experience. It does look better to have two degrees over the average college grad, but not better than a guy with one degree and one year of experience. Just the way the job market works, unfortunately at the time of graduation even :-(. Something for you to decide is what you want to do. Do you want to do the programming, or just know it and help in the design and architecture. Might want to aim for an entry level software engineer/architect or possibly something with business intelligence.

Are you able to hit the dyndns address from the local computer that apache is running on and access it?

Also are you able to hit the address in the same network and through dyndns in the same network?

Check and see if these are different args for you before the application.run

string[] args = Environment.GetCommandLineArgs();

Does it implement ISerializable?

mono incorporates the .net libraries into linux, it allows apache to use mono to host the asp.net pages

either get it through the repositories or
www.mono-project.com

sure you are hitting the same database?

also, is it a long running query? if so, might want up your limits

Having data type as what?

What are you not understanding?

you want a single stored procedure to do all of that?

i would advise to separate each out

not sure what your table structure is like but something like this should work

select * from userlogins ul
inner join userdetails ud
on ul.USER_ID = ud.USER_ID

double quotes

$master_id=mysqli_insert_id($mysqli);
}else{
$master_id=$_POST["master_id"];
}

right click on the project and click set as startup project

also might want to try restarting visual studio

it thinks f_name and l_name are one field, and l_name isn't supplied

do an echo to see what you're query looks like, you'll see why whenever you see what the query really is

echo $add_master_sql;

do this before you set $add_master_res

where are you wanting to see them at?

errors, or just something with the display?

might want to look at integration with windows live, i'm not sure if this piece allows hotmail access, but it looks like that might have support sometime

http://www.microsoft.com/downloads/details.aspx?FamilyID=847CAEB0-3EA4-498F-B57C-E75E1961619C&displaylang=en

use it in the select statement, not the output

why don't you just add the '$' in front of your row right here?

well depending upon what email provider you might be able to use an api or webservice call

for example gmail
http://sourceforge.net/projects/gmail-api

if not, then you might want to simulate the login and do screen scraping on the page that is returned

yes

remember though, you can't do calculations with it, you might want to pull back the real value, and with a symbol

select columnName, concat('$', columnName) as  amount from tableName;

there isn't an update into

modify your update into personal_notes to just be

update personal_notes

You can do it with ajax

Msdn Site
http://msdn.microsoft.com/en-us/magazine/cc164247.aspx

Ajax Site
http://www.asp.net/ajax/ajaxcontroltoolkit/samples/modalpopup/modalpopup.aspx

not really sure what you are meaning

all characters will have an int value, and you can translate the int value back to a char

you can use ascii(char)
or
char(ascii)

select ascii('q')
-- returns 113

select char(113)
-- returns 'q'

use DECIMAL
you may not necessarily see it at first, but float uses a non exact number and decimal uses exact

the currency symbol is just a matter of display, add it to your code side instead of db side

Both in mysql and ms sql joined view work.

You create them just like you would any other view, instead of your table name in the from, just use the view name

you need to query the values that are incorrect
i don't know if you're variable is incorrect, or the insert is blowing up
you then check to make sure you have the required values, ande decide to commit or rollback based upon them

SET AUTOCOMMIT=0;
START TRANSACTION;
BEGIN
DECLARE addVar INT;
INSERT INTO Table1 (col1, col2)	VALUES (1,2);
SELECT col1 INTO add FROM Table1 WHERE col1=1;

IF (addVar = 0) THEN ROLLBACK;
ELSE
INSERT INTO Table2 (col3, col4)	VALUES (addVar , addVar );
COMMIT;
ENDIF;
END

here's a sample
http://db4free.blogspot.com/2005/09/atm-transfer-simulation.html

asp.net definitely offers ease of programming ability and sharepoint can offer almost the same, just much harder to integrate with your classic programming model

users do not install sharepoint, the only sharepoint piece is the server that runs it, think of sharepoint as something that uses asp.net, sql server, and iis together that exhibits to the user just a regular webpage or a cms system, the users don't necessarily see any different

to see if you need to pay for the license look at microsoft's site on it, i'm not necessarily sure of what you need

http://office.microsoft.com/en-us/sharepointtechnology/FX101758691033.aspx?ofcresset=1

sharepoint does offer pretty good stability, there are a lot of quirks along the way as you integrate it, but once it gets up and going it is pretty solid

other advantages i don't necessarily know, but if you are wanting a cms through sharepoint, definitely much easier to go with it than write your own, the bad aspect is you just can't create an aspx page and expect it to work as intended or deploy through your normal means

through my experience, go with sharepoint if it fits the solution and you are looking for a cms, if you are looking for a website just with minimal cms then create your own

see if you can download a package called dos2unix

depending upon what distro you are on, you can do something like this
apt-get install dos2unix

you can run it to convert your windows files in to linux encoded

it seems like it can't read the files properly

Think it might be an issue with the encoding

try changing a line of code on the linux machine and resaving

i don't think it is properly reading the utf(i think) encoding

Feel free to post the errors if you need assistance with them.

Once it is all straightened out with them, let me know what the result is on mono.

Compile errors?

I thought your first post said you didn't get any compile errors. Are you getting any error or just the form doesn't show up?