Database

FirstPrevNext

Re: ANY SUGGESION.... anujbanka178426-Feb-09 1:19 anujbanka1784 26-Feb-09 1:19  mu question is on clicking the same button can we add the data with same id . for update we have to use other button. Re: ANY SUGGESION.... Rupesh Kumar Swami26-Feb-09 2:02 Rupesh Kumar Swami 26-Feb-09 2:02  why not you create a extra variable which hold the ID of the department. set -1 for new department. If you edit any saved department, then replace -1 to ID of saved department. And finally on button click, check whether variable is equal to -1 then use insert query, otherwise use Update query Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11 Re: ANY SUGGESION.... Ashfield26-Feb-09 8:54 Ashfield 26-Feb-09 8:54  This is a somewhat stupid question, it all depends on your database design - if the id is a primary key then no, otherwise yes. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP The TCP/IP connection to host has failed - JDBC with sql Express [modified] Nada Adel25-Feb-09 20:45 Nada Adel 25-Feb-09 20:45  I'm using IReport and I'm trying to connect to the database on the server from my home computer. It works fine when I connect from my work computer that is on the same network as the server but it fails from home. I checked on everything, firewall is turned off on the server, all sql server services are running, The tcp/ip port 1433 is enabled and sql server authentication is enabled on sqlexpress. The url is: jdbc.sqlserver:// serverIpAddress:1433;DatabaseName=mydatabase It connects from my work pc, but at home it doesn't. Am I missing something? modified on Thursday, February 26, 2009 2:55 AM Re: The TCP/IP connection to host has failed - JDBC with sql Express Mycroft Holmes26-Feb-09 0:10 Mycroft Holmes 26-Feb-09 0:10  I think you just committed hari kari, I have not heard of someone attempting this for at least a decade, your exposure is extreme and there are automated systems that test 1433 for open connections. Having said that you may be lucky and the IP you are using is the local one on your office network and not a publicly accessible IP address. If you want to connect to your office SQL server then do it via web services not directly. Never underestimate the power of human stupidity RAH Re: The TCP/IP connection to host has failed - JDBC with sql Express Nada Adel26-Feb-09 0:20 Nada Adel 26-Feb-09 0:20  How do I find out which ip address to use in the url?? I'm using windows server 2003 Re: The TCP/IP connection to host has failed - JDBC with sql Express Mycroft Holmes26-Feb-09 0:44 Mycroft Holmes 26-Feb-09 0:44  No idea - as I said a decade since I have seen this done and it has moved on since then. Never underestimate the power of human stupidity RAH Re: The TCP/IP connection to host has failed - JDBC with sql Express Nada Adel26-Feb-09 0:47 Nada Adel 26-Feb-09 0:47  I now understand that I'm connecting to the ip address that the server and clients have locally which is not necessarily the same as the ip address that the remote database will see.. sql query parser me_aaryan25-Feb-09 19:20 me_aaryan 25-Feb-09 19:20  how to connect with database when entered select query is correct Re: sql query parser Rupesh Kumar Swami25-Feb-09 19:53 Rupesh Kumar Swami 25-Feb-09 19:53  me_aaryan wrote: how to connect with database use appropriate connection string for connect to database me_aaryan wrote: when entered select query is correct select query is used to select the data from database, not for connect to database Your question is confuse me . can you post more detail ? Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11 Re: sql query parser me_aaryan25-Feb-09 22:12 me_aaryan 25-Feb-09 22:12  i mean when the query is right then data should be dispalyed and to display i need to connect Re: sql query parser Rupesh Kumar Swami25-Feb-09 22:35 Rupesh Kumar Swami 25-Feb-09 22:35  what is the query and what is the language. can you provide some code snippet and elaborate how you perform the task? Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11 Re: sql query parser Mycroft Holmes26-Feb-09 0:03 Mycroft Holmes 26-Feb-09 0:03  You really are an idiot, you have asked the same question 3 times over the last month. You have no understanding of the question you are asking and therefore cannot understand the answers so you keep repeating the question, like a 5 year old. Remove your self from the forum until you get some more sense. Never underestimate the power of human stupidity RAH Sql query to select Date between the range pavanip25-Feb-09 18:56 pavanip 25-Feb-09 18:56  Hi, I am having database table as TicketNo,Name,Issue Date. I inserted the data for "IssueDate" field using calender control in Asp.Net. So the table data looks like this TicketNo Name IssueDate 1 xxx Feb 5 2009 12:00AM 2 yyy Feb 6 2009 12:00AM 3 zzz Feb 10 2009 12:00AM 4 aaa Feb 15 2009 12:00AM Now i want to write the query to select "IssueDate" between 02/04/2009 and 02/11/2009. Please Can anybody help me how to write query to retrieve the data between those dates? Thanks Pavani Re: Sql query to select Date between the range Mycroft Holmes25-Feb-09 19:13 Mycroft Holmes 25-Feb-09 19:13  pavanip wrote: select "IssueDate" between 02/04/2009 and 02/11/2009. almost had it in your question Select * from Tablename where IssueDate Between '02/04/2009' and '02/11/2009' Never underestimate the power of human stupidity RAH Re: Sql query to select Date between the range pavanip25-Feb-09 22:35 pavanip 25-Feb-09 22:35  I tried with that query but when i execute that query i am getting zero results but there are records in my table with that dates. I stored date value in varchar is it correct or i have to use only datetime datatype. Re: Sql query to select Date between the range J4amieC25-Feb-09 22:47 J4amieC 25-Feb-09 22:47  You need to store the date as a date. Why people store dates in a character field is totally beyond me. Re: Sql query to select Date between the range Mycroft Holmes25-Feb-09 23:56 Mycroft Holmes 25-Feb-09 23:56  As Jamie said, mistake 1 STORE YOUR DATES AS DATE TIME. So now that your have screwed your data you have 2 choices. Convert the dates from varchar to datetime - this is the recommended solution Make all the date values into datetime in your query. Select * from table name where convert(datetime,Stupiddate) between thisdate and thathdate Never underestimate the power of human stupidity RAH Re: Sql query to select Date between the range pavanip26-Feb-09 0:50 pavanip 26-Feb-09 0:50  Thanks for your response that query is working for my condition. Select * from tbl_ticketinfo where convert(datetime,issuedate) between '" 02/05/2009' and '02/09/2009' Re: Sql query to select Date between the range Rupesh Kumar Swami25-Feb-09 19:48 Rupesh Kumar Swami 25-Feb-09 19:48  select * from table where issueDate BETWEEN CONVERT(varchar, '2009-02-04', 111) AND CONVERT(varchar, '2009-02-11', 111) Rupesh Kumar Swami Software Developer, Integrated Solution, Bikaner (India) My Company Award: Best VB.NET article of June 2008: Create Column Charts Using OWC11 Re: Sql query to select Date between the range pavanip25-Feb-09 22:46 pavanip 25-Feb-09 22:46  I tried with this query select * from table where issueDate BETWEEN CONVERT(varchar, '2009-02-04', 111) AND CONVERT(varchar, '2009-02-11', 111) but when i execute that query i am getting zero results but there are records in my table with that dates. I stored date value in varchar is it correct or i have to use only datetime datatype. Re: Sql query to select Date between the range Mycroft Holmes25-Feb-09 23:58 Mycroft Holmes 25-Feb-09 23:58  Rupesh Wrong way - you are converting to varchar and comparing strings, you need to convert to datetime to use between! Never underestimate the power of human stupidity RAH Multiple Database Connections devi g25-Feb-09 16:23 devi g 25-Feb-09 16:23  How to connect to multiple databases (like SQL server, mysql, oracle) through Java code. Thanks, Nirmala What is the best way to place database on client 's machine? r_mohd25-Feb-09 15:48 r_mohd 25-Feb-09 15:48  Hell all, i have developed an application say inventory management in vb.net/ ms sql. now i want to install this application on different machines of my clients. i have written maximum code in Sp's and have fear that some one copy it or edit/delete it. kindly suggest me a best way in which no one copy my database or edit/copy/delete it. thanks in advance rmshah Developer Re: What is the best way to place database on client 's machine? PIEBALDconsult25-Feb-09 16:06 PIEBALDconsult 25-Feb-09 16:06  That's a big reason not to use stored procedures. If it's your client's system, you can't lock them out from doing silly things to it, yet you will likely be responsible for repairing any damage they do. At best you could have a written agreement that clearly states what happens when they screw up the system. I've was only required to write stored procedures for one client, and it as dreadful.

Last Visit: 31-Dec-99 18:00     Last Update: 27-Apr-24 19:15 Refresh ᐊ Prev1...895896897898899900901902903904 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.