Posts by dickersonka

area codes are a little tricky and sort of hard to get a direct correlation with a physical location

i think it would be best to leave them separate

for example atlanta has 3 area codes, but those area codes are also used in other cities, suburbs also share those 3 area codes, multiple cities, sharing duplicate multiple area codes

plus a user can have an area code from another place if they moved

very good, aren't you happy with this diagram compared to how you started?

so what is your next step with this?

Lol always helps to have a second set of eyes.

Sure just give the link for your new diagram and i'll check it out.

yes sequential inserts into the rest of the tables after user, the ripple effect you are wanting, is only on updates and deletes, you can't necessarily insert and populate tables the way you are wanting without triggers, but thats a whole different story

now the location thing
what you were allowing with the way you had it before was a user to have a city that wouldn't belong to the correct country, postal, or area code and vice versa

think of it just as you stated it, a country has area codes, area codes have cities, cities have postal codes

(the area code doesn't necessarily match because its phone based, but anyways)

take for example there is a toronto us and canada

we will take area codes out of this example

country
1 us
2 canada

cities
cityid cityname countryid
1 toronto 1
2 toronto 2

postal codes
postalcodeid postalcode cityid
1 11115 1
2 11116 1
3 45428 2

that is the concept, also you i don't know about how canada is, but countries have states, states have cities, cities have postal codes, which maybe states is what you are meaning area codes

sorry i mistyped my id from before, you were correct, it should be 1 2 3

sounds good, stick with mssql

take a look at here
http://us2.php.net/manual/en/function.mssql-query.php

its the querying aspect of php with mssql

its hard to say what you need to know, but a majority of it will be mssql_query, displaying data, and inputting data

after that all done, lol you should be about done with your project already

also your city, country, and area code tables are out of sync

the way you have it, a city could have a different postal code, different country and different area code

the relationship should be
country --> areacode --> city -->postalcode

a country has area codes, which has cities, which have postal codes

ok lets start with the database side then, which db are you more familiar with mysql, mssql, oracle, something else?

since you are just starting, i would recommend php, asp.net is good just a bit to learn in a hurry, jsp might be confusing to just dive right in, php at least seems like a good start

good tutorial would be at php's site, search google for php tutorial and you will find plenty
http://us.php.net/tut.php

php will do what you need to do, many commercial and personal sites are done in it, its not necessarily hard to learn, just takes patience and time as does any language

yes, you can drop users_airports_link

i don't know which 3:37 post is, but i assume its the one with the data

airports
aid airport code
1 hartsfield ATL

services
1 movies on board
2 international flights

users
uid usr_fname
1 john
2 jane

userairportservices
uas_id user_id service_id airport_id
1 1 2 1
2 2 1 1
2 2 2 1

this will show user_id 1 (john) has international flights at atl

this will show user_id 2 (jane) has international flights and movies at atl

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 a good stepping stone "into the real world"

you have a few options
probably the most popular and best languages for the task would be asp.net, php, or jsp

you familiar with java or .net? or experienced with a scripting language?

But the choice of which services they have should only be made after the airport relationship is defined.

i thought this meant airports have different services

this table structure can be used, or you can use this one

userairportservices
user_airport_service_id
user_id
airport_id
service_id

and drop the airportservices table

the airport services will have something like this

as_id a_id s_id
1 1 1
2 1 2

services
1 movies on board
2 international flights

userairportservices
uas_id user_id as_id
1 1 2

this means the airport offers two services, but the user only has access to 1 service, userid of 1 can only have a service of international flights at airportid 1, but airportid 1 offers 2 services

yep that looks good, the other way to do it would be to replace user_id in user_airport_services with user_airports_link, but there could be a constraint violation if the user was ever removed from an airport

what do you mean as far as the user inserting into the tables?

then just as ezzaral stated its the radiusint getter

also i would suggest you to name it as

public int getRadiusInt()

just as your other ones have been named

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

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

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

i'm assuming you are meaning k nearest neighbor?

interesting stuff
http://en.wikipedia.org/wiki/Nearest_neighbor_(pattern_recognition)

amazing batol, there is even a code link on the wikipedia page

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
http://www.lifeaftercoffee.com/2006/02/17/how-to-create-auto-increment-columns-in-oracle/

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

http://bytes.com/forum/thread458947.html

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.

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

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

[assembly: AssemblyVersion("1.1.1.*")]

here's a post that should help you out

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

have you tried with network stream instead?

NetworkStream netStream = new NetworkStream(sender);

//...other code
while ((bytesRec = netStream.Read(bytes, 0, bytes.Length)) > 0) 
{
 Response.Write(Encoding.UTF8.GetString(bytes,0,bytesRec));
}

lol you have to give him an A for creativity

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

also since this is an asp.net app, try running it as a regular windows or console app first, see if the problem still exists

so that timeout didn't correct the issue?

possibly try changing the

ReceiveBufferSize

then just as tim said, add an AdminId column to each table that will be modified by that user and record this id as the user

these will have 1 to many (admin can have multiple relationships to hall, branch, movie)
(1..x)
admin ------> hall
admin ------> branch
admin ------> movie

hall -> branch -> movie -> seat -> customer

then we will have the same structure as before

try this then above the while loop

//Milliseconds wait time for timeout
send.ReceiveTimeout = 1000;

make sure the sql server service is running

See if this changes anything

while ((bytesRec = sender.Receive(bytes)) > 0) 
{
   Response.Write(Encoding.UTF8.GetString(bytes,0,bytesRec));
}

how is this random?

• articles with higher values of 'type' appear first
• then all the articles with 'type=0' should appear at the end
• then all the articles with a low section ID should appear

you need to pick one or the other, sorting with type and section or not

i don't see how you can have both

you are creating a file with a pdf extension, not an actual pdf file

you need to use a either a converter or a printer to create the file

i normally use pdf995.com

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

are you using mssql or mysql? or another variation?

His date was on the same day and 5min 16sec apart, thats why i didn't use days

after insertion do this

Response.Redirect("../Prototype/AddConfirm.aspx");

normally postback will occur to your same page, but postbackurl changes to the other page, thats why your insert doesn't occur

Not sure if you are in the US, but if you are, might try craigslist

public class Translate {
public static void main(String [] args){
String filename = null;
if(args != null && args.length() > 0){
filename = args[0];
}
}
}

row count is easy, just use

select count(*) from table

what is the character set of the db?

here is some pseudo-code for you

List<Book> usefulBooks;
int cashAvailable = cash;
booklist = query books by usefulness descending
for(Book book : booklist)
{
if(cashAvailable - book.getPrice() > 0)
{
//add the book
usefulBooks.add(book);
//decrement our cash
cashAvailable = cashAvailable - book.getPrice();
}
}

lol wow, msdn is terrible

here's a different link, but still everything is the same concept
http://en.csharp-online.net/Working_with_Data%E2%80%94Using_the_DataGridView

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

here is the sql code to get it

SELECT
sysobjects.name AS "TABLE_NAME", 
syscolumns.name AS "COLUMN_NAME", 
systypes.name AS "DATA_TYPE", 
syscolumns.LENGTH AS "LENGTH" 
FROM         
	sysobjects 
INNER JOIN 
	syscolumns ON sysobjects.id = syscolumns.id 
INNER JOIN                      
	systypes ON syscolumns.xtype = systypes.xtype 
WHERE     
(sysobjects.xtype = 'U') and
sysobjects.name = 'MyTableName'
ORDER BY sysobjects.name, syscolumns.colid

then in your your datacolumn, you will set maxlength to the value returned from the query for length

DateDiff(ss, MoviePayedDate, getdate())

this will return the difference in seconds, which i think is what you need, then convert it to minutes, if you want minutes, use mi instead of ss

this isn't necessarily pertinent to vb, but normally what you would do is create a locked column in the database, whenever they start reserving set it to locked and not allow any other users to access when the column is set

i think this is wrong

JDBC_DRIVER = getInitParameter("com.mysql.jdbc.driver");

you have a param in your config with this?

try changing it to this, at least for debugging purposes

JDBC_DRIVER = "com.mysql.jdbc.driver";