Posts by dickersonka

the insert should take no time at all, are you sure its a locking problem?

check and see if the last post here helps you out

http://www.webmasterworld.com/forum21/4619.htm

if we do it, that will only get you as far as your next assignment, its the ol teach a man to fish saying

i know you have quite a list of instructions, so break them down, focus on one account at a time, look at how it will be implemented and how you can using the functionality of your base class for it

i think you are seeming to be worried about the load, vs the concurrency

i would suggest using stored procedures with transactions

there is no problem with inserts, as long as they won't bust unique constraints or allow a user to join against them, when data isn't finished being populated

selects may involve 100-2000 records, for multiple clients, as long as the server can handle the load, then its not really a concurrency issue

here's an article that might be of interest
http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/

let me give a sample schema and maybe that will help you understand

users
USER_ID
FIRST_NAME
LAST_NAME

log
LOG_ID
USER_ID
LOG_MESSAGE
LOG_DATE

you can't use a subquery on the table you are wanting to be updated

Is the other page refreshing a panel or anything? You need to remember, once the page is loaded it won't make another server call to get your chat messages unless you tell it to.

masijade is correct, i think its more of a convention to follow though

just like your variable names

int MyAge,Age;
//need to be named
int myAge, age;

and with the overrides its much easier to tell what methods are implementing its base class, than sorting through the code

its pretty clear

some recommendation i would make, is to try to get it 3nf

for example project->areas, this is a varchar, might consider making a separate table, but if its not that big of a concern then keep it the way you have it

i think you will need a usertype column on the user table
otherwise, how will you be able to tell who is student, supervisor, coordinator

it will allow up to 4

i would either go with some client side code, or used a stored procedure that will check the length before inserting and reject the data

this does sound more like a business rule, so i would say keep it in the business logic portion of the app

show us your effort with some code and we will help

1. no, you should still have your complete db, make sure they did a full backup

2. don't understand, where are you getting this data from? the backup?

3. you can do it right in sql server, depending on your version its either DTS or SSIS

not for sure, but i would say because that parameter was never used and i figure he took it out

@DateRented become GetDate()
@DateDue become GetDate() + 5

so i believe he originally had them in the stored procedure as parameters, and then removed them to fix the problem, as they weren's used

yes that should work

you could also use a subselect on the table

select DISTINCT col1 FROM t1 WHERE ..... and col1 in (select DISTINCT col1 from t1 WHERE .....)

are you sure you have permission to that directory from iis?

try moving the images to inetpub in your directory there

also if that doesn't work, use

Server.MapPath(imagePath);

Rude, for giving him a link with what it is with code and saying to clarify the question?

Doesn't look like a good way to start off here RC131, when we are trying to help.

Ok, take a shot at you have then we will help you out with what you need

Good job then, lol who know what was going on before

please post this in your other post and close this one

converted into object oriented code? what language if so?

Lol nice one ddanbe

Are you talking about creating an email, or just adding a document to be postback?

Take a look at the fileupload control

this might be classic, but how about something that will show you your network of unix servers, uptime, what they offer(mysql, apache, ....)

sure, post what you have then we can go from there

don't get caught up that this is a repeater, a repeater is very simple, it just automatically loops through the datasource for you

select 
  count(*), 
   p.post_id, 
   p.user_id, 
   u.username 
from 
   Posts p 
inner join 
   Users u 
on 
   p.user_id = u.user_id
where
  p.user_id = ?

that will be for a single user, if you want something for a view, remove the where and query the view

why not just delete the row from your datasource and reload the grid?

is the user on the system? or is the user only in the database?

and which user are you creating the folders with?

if you are able to get records from one, why are you having trouble with the other?

post your code as well, so we can help

wow, thanks for all the links, might be able to take a day off from google now :-)

def so, 2007 is much different than 2003

i would create a method called isInSet and you iterate through the characters and check, you can't do a character check the way you are wanting to unless you add them to a list or an array of some sort

so you aren't having trouble submitting the forms, you just need to know how to create calendar appointments?

http://www.outlookcode.com/codedetail.aspx?id=775

do a google search for exchange with c#

just make sure not to call form.Hide()

you might also show other forms as dialogs depending on your needs

either go with a timestamp or id column, assuming its an integer or bigint

select * from table order by idcolumn desc limit 10

select * from table order by timestampcolumn desc limit 10

the syntax for java really isn't that much different, the declarations for classes, inheritance, variables, and getters/setters and some key points that will be different

a lot of times you would change the database type if you are moving to a windows system for hosting among many other reasons

and you are getting 0's for everything after you put in lets say 3 entries?

hmmm, i have the same code and it is working for me

this piece is above the while loop

if (grade>=0 && grade<=100)

the piece of code i meant

if (highest<grade){
				highest=grade;
				}
				if (lowest>grade){
				lowest=grade;	
				}

needs the bottom if to be changed to

if (highest<grade){
highest=grade;
}
if ((lowest>grade)  && (grade > -1)){
     lowest=grade;	
}

read closely at my previous post

notice 100.0

Apercent = (((double)Acounter/counter)*100.0);

i know you have an if statement before the loop, the problem is that you are reading inside the loop for it to terminate, thats why you need that check in there

grade = input.nextDouble();

that is inside the loop and won't hit your if check

sort of depends, what version of outlook are you using? And are you using exchange?

Yes you can do it, either make sure there is either a mapped drive, or it can be shared, if you run into problems with the firewall make sure file sharing is enabled in the firewall, i believe it is ports 135-139 if you run into problems

looks like lowest grade needs to be changed a little bit

if ((lowest>grade)  && (grade > -1)){
     lowest=grade;	
}

not necessarily like you are wanting i doubt

you can create a linked server from mssql and do it
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx

its a link for 2000, but should still work

you need to check the rpc service on the remote machine

you are saying transfer your xml file from the remote machine all the information you need? or you are transferring to the remote machine?

what about this

Apercent = (((double)Acounter/counter)*100.0);

first you are missing an else on your first if checking jobid

after the insert use,

return @@IDENTITY

from codeside add a parameter with

ParameterDirection.ReturnValue;

just when we thought we were caught up :-)

that one changes revision btw

also check the same for

AssemblyFileVersion

you can look at it in
Project -> Properties ->Application -> Assembly Information

also if you really feel lazy you can use this add in
http://www.codeproject.com/KB/macros/vsautover.aspx

sure feel free
it won't be that hard once you get the concept

for your new questions close out this thread and start a new one

look forward to your new questions

keith

it is because although text and varchar may look the same, they are not, the actual data is a different type and can't be compared without converting

recommendation
the only part that should be in the where clause is the jobid and it should be an int or bigint value most likely, you don't want to have to keys as strings

change your text's to (n)varchar's, set dates to datetime, and all id's to ints or bigints

then your new sql statement will be

UPDATE [JobVacancy] SET [JobName] = @JobName, [BriefDesc] = @BriefDesc, [FullDesc] = @FullDesc, [ClosingDate] = @ClosingDate, [JobSpec] = @JobSpec WHERE [JobID] = @original_JobID AND [JobName] = @original_JobName AND [BriefDesc] = @original_BriefDesc AND [FullDesc] = @original_FullDesc AND [ClosingDate] = @original_ClosingDate AND [JobSpec] = @original_JobSpecUPDATE [JobVacancy] SET [JobName] = @JobName, [BriefDesc] = @BriefDesc, [FullDesc] = @FullDesc, [ClosingDate] = @ClosingDate, [JobSpec] = @JobSpec, [JobName] = @original_JobName, [BriefDesc] = @original_BriefDesc, [FullDesc] = @original_FullDesc, [ClosingDate] = @original_ClosingDate, [JobSpec] = @original_JobSpec
WHERE [JobID] = @original_JobID