dickersonka

you'll need to use [code] Select table3.DocID, sum(table1.Freq + table2.Freq) as Freq -- your from and where group by table3.DocID order by SUM(table1.Freq + table2.Freq) desc [/code] i added the order by for clarity

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

how about [code] int myValue = 6000; Debug.WriteLine(Convert.ToString (myValue, 2)); [/code] little less lines of code

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

i think this is wrong [code] JDBC_DRIVER = getInitParameter("com.mysql.jdbc.driver"); [/code] you have a param in your config with this? try changing it to this, at least for debugging purposes [code] JDBC_DRIVER = "com.mysql.jdbc.driver"; [/code]

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 …

show us your effort with some code and we will help

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 …

create two tables, airportservices and userairportservices airportservices AIRPORT_SERVICE_ID AIPORT_ID SERVICE_ID userairportservices USER_AIRPORT_SERVICE_ID USER_ID AIRPORT_SERVICE_ID this will allow airport services to hold the services at the airport and the userairportservices to hold the relationship between user and airport_service

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 …

yes that should work you could also use a subselect on the table [code] select DISTINCT col1 FROM t1 WHERE ..... and col1 in (select DISTINCT col1 from t1 WHERE .....) [/code]

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 [code] Server.MapPath(imagePath); [/code]

is the user on the system? or is the user only in the database? and which user are you creating the folders with?

please put code in code tags, and what is the error?

very clear question and thanks for showing your effort and what you are having trouble with i'm not too big on vocabulary, but you want to try to get the database to use third normal form something like this for your bookingrecords table bookingrecords CLIENT_ID DATE REQUIRED_HOURS REQUIRED_SERVICE_CODE clients CLIENT_ID …

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

what about this [code] Apercent = (((double)Acounter/counter)*100.0); [/code]

please post this in your other post and close this one

same thing as in the forum PreparedStatements [url]http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html[/url]

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

Are you talking about creating an email, or just adding a document to be postback? Take a look at the fileupload control

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

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

so you aren't having trouble submitting the forms, you just need to know how to create calendar appointments? [url]http://www.outlookcode.com/codedetail.aspx?id=775[/url] do a google search for exchange with c#

just when we thought we were caught up :-)

either go with a timestamp or id column, assuming its an integer or bigint [code] select * from table order by idcolumn desc limit 10 select * from table order by timestampcolumn desc limit 10 [/code]

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

not necessarily like you are wanting i doubt you can create a linked server from mssql and do it [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/mysql.mspx[/url] its a link for 2000, but should still work

please put code in code tags, give us a specific error or problem you are having, and show us what piece of code you are having trouble with

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?

row count is easy, just use [code] select count(*) from table [/code] what is the character set of the db?

first you are missing an else on your first if checking jobid after the insert use, [code] return @@IDENTITY [/code] from codeside add a parameter with [code] ParameterDirection.ReturnValue; [/code]

think you got your revision number hardcoded probably if its not changing, take a look at your assemblyinfo.cs file you can do this get revision to change automatically [code] [assembly: AssemblyVersion("1.1.1.*")] [/code]

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 …

Sure, i don't understand how you are "accessing" this other program though.

well it sounds like you have your idea already your spec should say what the existing company has, what you are going to do for them, what they will be able to do when you finish, and how you will accomplish this as far as the website it will be …

[code] for ( int i=0; i<num; i++ ) { result += str + "\n"; } [/code]

lol wow, msdn is terrible here's a different link, but still everything is the same concept [url]http://en.csharp-online.net/Working_with_Data%E2%80%94Using_the_DataGridView[/url] the steps are pretty basic, create a connection, create a dataadapter, execute a query to fil lthe datasource, and set the datasource on the gridview

lol you have to give him an A for creativity

sql plus is for oracle not for sql server how are you inserting the record? i think you are meaning autoincrementing here is how to do it in oracle [url]http://www.lifeaftercoffee.com/2006/02/17/how-to-create-auto-increment-columns-in-oracle/[/url]

you could use SQL Profiler and it will show you all queries being executed, it will save you a lot of work from creating new tables and triggers and show you all sql statements being ran

dangerous, yes and not recommended here's a post about what you want to accomplish [url]http://bytes.com/forum/thread458947.html[/url]

Have you checked out your drivers? Also safe mode with networking?

Born and raised in West Virginia. Pretty tough on the programming job market there, thats why I'm in Atlanta now. Good job on getting an opportunity.

When you say there is a relationship between the admin and the other entities, what do you mean? They are allowed to edit as far as UPDATES, INSERTS, and DELETES or do you mean the admins are the owners of the movie hall? And just to be sure, hall means …

are you using a foreign key on the name column?

Calm down Post the section of code that is not working properly and let us know your problem, then we will help its much easier to work on pieces of the complete problem, than the whole thing all at once

See if this changes anything [code] while ((bytesRec = sender.Receive(bytes)) > 0) { Response.Write(Encoding.UTF8.GetString(bytes,0,bytesRec)); } [/code]

you need to install sql server express, along with management studio, management studio is only the gui front end