Database

Select multiple fields into a new fields then do a like statement

5-Sep-07 14:09

dinakatina wrote:
i want a website which demonstrates the travel agent system showing their database design and relational tables

You are most unlikey to get this unless someone has used a travel agent system as an example in a text book.

Have you considered designing your own database?

Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ...

My website

MyRunner5-Sep-07 10:13

MyRunner

5-Sep-07 10:13

Hi All,

I need to do a select statement with will combine two fields into one before I do the Like statement.

i.e.

Table1.SuiteNumber
Table1.Address
Table1.Country

Combine these 3 fields into one field called FullAddress

Select suitenumber + " " + Address + " " + Country AS FullAddress From Table1

THEN select particular record in the FullAddress field

Select * from Table1 where FullAddress like %Owl street%

How can I combine this two select statement into one? Please advice. Thanks in a million.

gsdg

Re: Select multiple fields into a new fields then do a like statement

Colin Angus Mackay5-Sep-07 10:24

Re: Select multiple fields into a new fields then do a like statement

5-Sep-07 10:24

SELECT suitenumber + ' ' + Address + ' ' + Country AS FullAddress 
FROM Table1
WHERE suitenumber + ' ' + Address + ' ' + Country LIKE '%Owl Street%'

Colin Angus Mackay5-Sep-07 10:26

travel agent database problems

5-Sep-07 10:26

Alternatively

SELECT * 
FROM (SELECT suitenumber + ' ' + Address + ' ' + Country AS FullAddress 
      FROM Table1) AS subquery
WHERE FullAddress LIKE '%Owl Street%'

dinakatina5-Sep-07 9:02

dinakatina

5-Sep-07 9:02

i design a website about online reservation systems in travel agents ,and i face many problems database design stage one of these problems is how to display the description of the day for (certain day of certain package)
the second problem if an individual reserve online and fill the reservation form (without going to an agent that exists in his country )should i put him/her in a filegroup or not
if anyone is familiar with tourism fields and its system,please give me advice,i need it urgently,thanks a lot

Colin Angus Mackay5-Sep-07 9:06

5-Sep-07 9:06

dinakatina wrote:
how to display the description of the day for (certain day of certain package)

That is an ASP.NET problem.

dinakatina wrote:
if an individual reserve online and fill the reservation form (without going to an agent that exists in his country )should i put him/her in a filegroup or not

I don't know. What does your client want to happen in that situation?

Christian Graus5-Sep-07 10:09

Christian Graus

5-Sep-07 10:09

Gotta love the people who 'need it urgently', but don't respond when you try to help.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Colin Angus Mackay5-Sep-07 10:29

5-Sep-07 10:29

Christian Graus wrote:
Gotta love the people who 'need it urgently', but don't respond when you try to help.

It happens. I'm trying not to lose my cool with that sort of thing, so the odd vent on my blog helps. I'm actually trying to vent more frequently so it doesn't build up. Of course, that makes less fireworks for everyone else to see.

Christian Graus5-Sep-07 9:08

Christian Graus

5-Sep-07 9:08

Is this a real world system ?

dinakatina wrote:
if anyone is familiar with tourism fields and its system,please give me advice,i need it urgently,thanks a lot

I can only assume that you've taken a job to write this system, the real question is, why are you asking us what your client wants, instead of asking your client ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

T-SQL Help

Hulicat5-Sep-07 8:04

5-Sep-07 8:04

SQL 2000 8.00.2039

I am trying to write a backup from SQL (.bak), compress it then insert into a
database.

Can someone help me with the framework of this operation?

Any input is greatly appreciated.

Regards,

Regards,
Hulicat

Colin Angus Mackay5-Sep-07 8:32

5-Sep-07 8:32

Hulicat wrote:
Can someone help me with the framework of this operation?

What do you mean by "framework" in the current context?

Hulicat5-Sep-07 8:42

5-Sep-07 8:42

Sorry I should have been more specific.

I am trying to accomplish the aformentioned operation via T-SQL.

The only way I have seen is via C# or ASP.

What would the T-SQL look like to achieve the goal of compressing a .bak file then storing the file in the database?

Could I execute a backup, compress it, then drop in the db as a blob?

Regards,
Hulicat

Colin Angus Mackay5-Sep-07 9:04

5-Sep-07 9:04

Hulicat wrote:
Could I execute a backup, compress it, then drop in the db as a blob?

Yes. You could use BACKUP, xp_cmd (and call out to a zip application), but I'm not sure how to get it back in the database as I usually do that from within a C# application.

Hulicat5-Sep-07 10:21

5-Sep-07 10:21

It looks like it have to be C3

Regards,
Hulicat

Colin Angus Mackay5-Sep-07 10:23

5-Sep-07 10:23

Hulicat wrote:
It looks like it have to be C3

Hulicat5-Sep-07 11:13

5-Sep-07 11:13

Regards,
Hulicat

Pete O'Hanlon5-Sep-07 12:14

Pete O'Hanlon

5-Sep-07 12:14

Colin and I are from the UK. The 3 key has the £ sign and not the # sign here. Big Grin | :-D

Deja View - the feeling that you've seen this post before.

High Volume of Insert Statement

Steven J Jowett5-Sep-07 22:27

Steven J Jowett

5-Sep-07 22:27

Pete O`Hanlon wrote:
The 3 key has the £ sign

It's not a sign, it's a symbol. How picky am I? Poke tongue | ;-P

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

logicon5-Sep-07 6:38

logicon

5-Sep-07 6:38

Hi All,

I am working on an application in which on every 100 miliseconds there is an insert statement executing. I am using MySQL server as database and ODBC connector. Can anyone please suggest me how should I change the application's architecture to do this in a better way. Currently on every insert I am creating an connection and command object to perform the INSERT operation.

Regards,
Amit

Colin Angus Mackay5-Sep-07 8:34

5-Sep-07 8:34

I'm going to assume that the application is written using a .NET language because you've not indicated otherwise. If this is incorrect please say.

Use SqlConnection, SqlCommand, etc. rather than the ODBC varients.

logicon5-Sep-07 9:33

logicon

5-Sep-07 9:33

Yes, server part in which INSERT statement has to occur on every 100 millisecond is written in C# using VS 2005. Database MySQL 5.0.

These INSERT statements has to occur anyhow in silent mode (in background) while user can do other Add/Edit/Delete or Update related operations on Database. Actually these insert statements are executed for the data received by the server application on an interval of 100 to 500 millisecond.

Please suggest a better way to do this.

Colin Angus Mackay5-Sep-07 9:45

5-Sep-07 9:45

Sorry, I misread your original post, I though you said "SQL Server" not "MySQL".

You should use the appropriate .NET Data Providers for your database.

logicon wrote:
These INSERT statements has to occur anyhow in silent mode (in background)

If you are writing a .NET application you have to define any user interface that may be updated as a result of any database interaction. It is all "silent mode" unless you write code to the contrary.

logicon wrote:
while user can do other Add/Edit/Delete or Update related operations on Database.

So, you have multiple threads interacting with the database. MySQL supports transactions now so that isn't a problem.

logicon wrote:
Please suggest a better way to do this.

Don't use ODBC, use the appropriate .NET data provider for your database. Other than that, there isn't a better way.

logicon5-Sep-07 11:05

logicon

5-Sep-07 11:05

Thanks Colin,

Problems with current application is that its highly unstable. Some times it works file and sometime the insertion operation fails and gives exception. Even on some test machine it is working file since a long time, but on some other machine it gives exceptions on some insert operations.

I find my self helpless with the provided stack trace.

Which .NET provider is suitable for MySQL 5.0 and VS 2005?

Regards,
Kumar

Colin Angus Mackay5-Sep-07 12:36