Database

Re: sql server mobile edtion connectivity with windows mobile 5.0 application problem

5-Sep-08 3:22

First, of all your question belong to 'Mobile Development' board.
Second, check this link[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

manish.singhal6-Sep-08 2:29

manish.singhal

6-Sep-08 2:29

hi,

thanks for ur reply i sorry i must had post it there .............................those strings r not working ..................................can please me some peace of code or application sample ...........

thanks

Thanks & Regards
Manish Singhal
Software Engineer
Maxworth systems(Delhi)

time out expired

brettokumar4-Sep-08 21:12

brettokumar

4-Sep-08 21:12

hi i ma using a query like to select country code using between query cause ip

if im using this query i will fetch value sometime but i will display time out expired error some time.

to over come this problem what can i to do

can share your ideas with me

my query is

SELECT countryShort FROM IPCITYLATLONGISP WHERE '3678433939' between ipFrom and ipTo

with regards,
bretto

Re: time out expired

Blue_Boy4-Sep-08 21:38

4-Sep-08 21:38

Try to optimize your query.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: time out expired

Paddy Boyd4-Sep-08 23:54

Paddy Boyd

4-Sep-08 23:54

Have you considered putting an index on this column (you need to consider that while it may speed up your query, it might also slow down your inserts).

Re: time out expired

Ashfield5-Sep-08 1:16

Ashfield

5-Sep-08 1:16

Besides optimizing your query (perhaps by indexing the column) you can increase the query timeout in your code.

Bob
Ashfield Consultants Ltd

dymanic sql query

nelsonpaixao4-Sep-08 12:42

4-Sep-08 12:42

Can anyone help me here? i need to use this method D'Oh! | :doh:

declare @season as varchar(4)
set @season = '2004'
declare @sql1 as varchar(max)
declare @sql2 as varchar(max)
declare @sql3 as varchar(max)
select @sql1 = 'create table driver_'+@season+'(id int, f_name varchar(50),l_name varchar(50))'
exec (@sql1)
declare @id int
declare @f_name varchar(50)
declare @l_name varchar(50)
set @id = 123
set @f_name = 'lewis'
set @l_name = 'hamilton'
select @sql2 = 'insert into driver_'+@season+' values(@id,@f_name,@l_name)'
exec (@sql2)
select @sql3 = 'select * from driver_'+@season

Error msg: Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@id".

Not declared he says!!! Mad | :mad:

nelsonpaixao@yahoo.com.br

Blue_Boy4-Sep-08 13:25

4-Sep-08 13:25

here it is:

<br />
declare @season as varchar(4)<br />
set @season = '2004'<br />
declare @sql1 as varchar(255)<br />
declare @sql2 as varchar(255)<br />
declare @sql3 as varchar(255)<br />
select @sql1 = 'create table driver_'+@season+'(id int, f_name varchar(50),l_name varchar(50))'<br />
exec (@sql1)<br />
<br />
select @sql2 = 'declare @f_name varchar(50)<br />
declare @l_name varchar(50) declare @id as int  set @id = 123 <br />
set @f_name = ''lewis''  <br />
set @l_name = ''hamilton'' insert into driver_'+@season+' values(@id,@f_name,@l_name)'<br />
exec (@sql2)<br />
select @sql3 = 'select * from driver_'+@season

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

nelsonpaixao4-Sep-08 13:45

4-Sep-08 13:45

thanks i will check it now Rose | [Rose]

I was thinking on doing that has in the before code, didn´t tryed yet
Don´t you know other way?

No need to anser

nelsonpaixao@yahoo.com.br

Blue_Boy4-Sep-08 13:46

4-Sep-08 13:46

I have tested and it has worked for me. Smile | :)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

nelsonpaixao5-Sep-08 13:26

5-Sep-08 13:26

Listen Blue_Boy thanks for the post Rose | [Rose]

it woorks fine.

It seems i didn´t need that yet, because i thought on creating new tables and drop them after "my search", so i needed to create tables with diferents names, (because they triggered the same sp code)

But i ended on doing a diferent loop: create 1 table, search it and drop it, created 1 table,search it and drop it etc...
(so i didn´t need diferent table names)

ALL OK, but if i needed to do your way?

I couldn´t manage to do your dynamic sql when i have to enter a sp parameter, like @season.

declare @my_sql varchar(max)
select @my_sql = 'bellow code'

use my_Database
go

create procedure season_standings

@season as char(4)

as

begin

...

end

go

thanks no need to anser D'Oh! | :doh:

nelsonpaixao@yahoo.com.br

trying to help & get help

LastModifiedDate

geekfromindia4-Sep-08 9:06

4-Sep-08 9:06

Hi guys,

We have a column "LastModifiedDate" columns in almost all our tables. We are currently using procedures to update lastupdateddate column. but every now and then developers forget to add this to their query.

Is their a way to make this automatic...should we use triggers for this??...
But again I m not sure if we should add triggers to all tables...

what's the best practice for this?

Any suggestions??

Keep DotNetting!!

GeekFromIndia

Wendelius4-Sep-08 9:45

Wendelius

4-Sep-08 9:45

Use triggers. Much better solution than to use separate procedure.

geekfromindia4-Sep-08 9:47

4-Sep-08 9:47

we are not using separate procs but every procs that updates any table...it updates this column also...

Keep DotNetting!!

GeekFromIndia

Wendelius4-Sep-08 10:12

Wendelius

4-Sep-08 10:12

So is every update and insert done via stored procedure and the developers are writing the procedures?

If that is true I would still go to triggers. In this way the database takes care of critical information (I understood that the date must be modified every time) and the developers don't have to remember to add this column to every DML operation. Also DML executed directly against the table is setting the date correctly if triggers are used.

Just wondering how you use the LastModifiedDate. If it simply shows the date when the record is last modified, it's ok. However if you use it for optimistic locking, the resolution isn't adequate.

Mika

geekfromindia4-Sep-08 11:36

4-Sep-08 11:36

Thanks Mika,

We are using it to update date for any change in the table...i guess i will be using triggers only..

thanks again for help

Keep DotNetting!!

GeekFromIndia

Wendelius4-Sep-08 11:41

Wendelius

4-Sep-08 11:41

You're welcome Smile | :)

nelsonpaixao4-Sep-08 14:16

4-Sep-08 14:16

Hi,

i don´t know if i can help you there but use sql getdatetime() function to get date automatically. You will get time when the procedure is triggered, don´t even need to ask nothing to the user.

I had a application on which i manage the login/logout process automatically, the user doesn´t even know that it exists

algorithm:

create table log_table(id int,user varchar(50),login smalldatetime, logout smalldatetime)

--in login procedure
insert into log_table(235,john,getdatetime(), null)

--in logout procedure
insert into log_table(235,john,null,getdatetime())

Good Luck Big Grin | :-D

nelsonpaixao@yahoo.com.br

geekfromindia5-Sep-08 4:15

Help me with the query strings.

5-Sep-08 4:15

yeah...thats the way we are doing right now...
but if your table is accessible at many places/procs in application it can be difficult to manage or make sure that every developer is adding this attribute.

if anyone missed it..our business logic will fail...so i feel its better to add a trigger once and forget about it..

but i was wondering if there are any disadvantages of using triggers???

Keep DotNetting!!

GeekFromIndia

shashi_code4-Sep-08 4:29

shashi_code

4-Sep-08 4:29

Hi I am developing a project which involves query strings.
I want when user selects a city from a drop down list it has to be passed to the next page and show the values from the database in the gridview based on the value selected in drop downlist.

My code is :

protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
{
string url = "Cityschedules.aspx?City="+ ddlCity.SelectedItem.Text;
Response.Redirect(url);

}

When the user Enters say "New Delhi"

It shud show the all the values where city is "New Delhi"

In Cityschedules.aspx

protected void Page_Load(object sender, EventArgs e)
{
try
{

string strSQLconnection = "Data Source=SHASHI-56B0C28E\\SQLEXPRESS;Initial Catalog=Project_Airways;Persist Security Info=True;User ID=sa;Password=sql2005";
SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM [ARS_Schedules] WHERE ([Origin_Place] = '@Origin_Place1')", sqlConnection);
sqlConnection.Open();
string Origin_Place1 = Request.QueryString["City"];
SqlDataReader reader = sqlCommand.ExecuteReader();
GridView1.DataSource = reader;
GridView1.DataBind();
}
catch (SqlException se)
{
Console.WriteLine(se.Message);
}
finally
{
sqlConnection.close();
}
}

I am getting exceprion
"{"The DataSourceID of 'GridView1' must be the ID of a control of type IDataSource. A control with ID 'SqlDataSource1' could not be found."}"

Also when this exception is solved i am getting another exception saying
"Must declare scalar variable @origin_Place1"

Thanks in advance

regards
shashi

Re: Help me with the query strings. [modified]

Blue_Boy4-Sep-08 5:21

Re: Help me with the query strings.

4-Sep-08 5:21

shashi_code wrote:
"{"The DataSourceID of 'GridView1' must be the ID of a control of type IDataSource. A control with ID 'SqlDataSource1' could not be found."}"

Check GridView1 property Datasource on Design if it has set SqlDataSource1 as datasourceid, if it has then remove it.

<br />
SqlCommand sqlCommand = new SqlCommand(" declare @Origin_Place1 as varchar (500) set @Origin_Place1='"+Request.QueryString["City"]+"' SELECT * FROM [ARS_Schedules] WHERE ([Origin_Place] = @Origin_Place1)", sqlConnection);

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Meenal Ronghe12-Sep-10 23:34

Meenal Ronghe

12-Sep-10 23:34

I was getting the same error. Ur soultion worked. Thanks a lot.
Meenal Ronghe.

Re: Help me with the query strings.

nelsonpaixao4-Sep-08 13:57