When you are restoring on the laptop, check the physical destination path of the data files being restored. It might be pointing to a different directory than the default data directory present on the laptop. Or maybe there are the "same named" .mdf and .ldf files already present in the data folder of the laptop. cheers, [r a w] Little Johnny was a scientist. Little Johnny is no more. For what he thought was H2O, turned out to be H2SO4.

Try putting a semicolon after the insert statement as well. (Before the select statement.) About your sql query, let me get this correct. You want to set the email id of Subscribers the same as that in Interests. Right? And what are you trying to do in the SQL statement? Are you inserting in the Interests table? And what does the Select statement do then? If it is fetching email from the subscriber table to be inserted in the Interests table, then where is the email target field in the insert statement? Little Johnny was a scientist. Little Johnny is no more. For what he thought was H2O, turned out to be H2SO4.

Jim Crafton wrote: Has anyone has anything like this happen in the states? This just sounds completely bizarre! I guess you wouldn't even want to know what the police or other bureaucratic organisations can do, in the "states" of India. :) I guess, it's the same everywhere. Something like the "Hundredth Monkey Phenomenon[^]", except that it's true. :) [r a w] Little Johnny was a scientist. Little Johnny is no more. For what he thought was H2O, turned out to be H2SO4.

Have you tried the properties Dock and/or Anchor for the panes/tabs? cheers, [r a w] I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Compare the fetched record with DBNull.Value and store either the value or a blank string in the textboxes. Something like TxtCusName.Text = Ds.CusDetail(RecordPos).CusName==DBNull.Value?"":Convert.ToString(Ds.CusDetail(RecordPos).CusName); This is C# code.. pls change it to your respective language.. It will check if the value returned by the CusName is and if yes, will store a blank string in the textbox. regards, [r a w] I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Are you sure, you have used proper deployment techniques for deploying asp.net applications bundled with crystal reports. There are licensing issues and you'd also need to include the crystal merge modules in your deployment package. Check it out here.. http://www.businessobjects.com/communityCS/TechnicalPapers/crnet_deployment.pdf[^] Hope it helps, cheers, [r a w] I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Hi, You could always pick up the IP of the requesting user from the Server Variables and pass that IP to a third-party geo-targetting component, like Netacuity [^], which in turn would tell you the location of the user. Then you can block or allow the user. Hope this helps, Rahul I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Hi Vaibhav, Question 1: What would be the matching details of a particular hotel, which would help us to determine, whether the two records submitted by the two providers are of the same hotel? Question 2: How can you be sure, that the hotel "Inter" sent by Provider A is the same as the hotel "InterCon" submitted by Provider B. If the address of "Intercon" is the same as that of "Inter", except for an extra comma, how can you determine that both the records are of the same hotel, programmatically? Question 3: What is/are the field/s that is/are common and unchangeable for both the records? As fas as your question goes. If we assume that only the id changes, and the rest of the details remain the same, then you can design the database this way.. **tblHotel** ---------- HOTEL_ID (pk) (IDENTITY) HOTEL_NAME HOTEL_ADDRESS and so on for the unchanging fields. ----------- another table would be there, **tblProviderHotel** ------------- PROVIDER_HOTEL_ID (pk) identity (just a key field) HOTEL_ID (fk from tblHotel) PROVIDER_HOTEL_ID (this would be the id, given by the providers, "inter", "intercon" etc) PROVIDER_ID (fk from Provider table if you want) ------------- Now in this scenario (inter and intercon scenario), tblHotel would contain just one record for the hotel details, whereas the tblProviderHotel would contain two records with the same HOTEL_ID (from tblHotel) but different PROVIDER_HOTEL_IDs (inter and intercon) Similarly, if a provider C sends you a record of the same hotel, but the id is differnt, say "Inter-Conti", then you can check if the rest of the fields such as HOTEL_ADDRESS, CITY, ZIP etc matches with any record in tblHotel and if it does as in thsi case, then take the HOTEL_ID for the matching record from the tblHotel and just make a new entry in the tblHotelProvider table, with the id that the provider gave you.. So now, you have 1 record in tblHotel, but 3 related records in tblHotelProvider all pointing to one hotel, but submitted by different providers.. Also this is implemented, assuming all the other details are matching for all the 3 hotel records provided by the providers..as I asked you earlier. Please do let me know if this helps.. Cheers, Rahul I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Hi novachen, I dont know why this is happening, but to explicitly break at some point, instead of using a breakpoint, try using System.Diagnostics.Debugger.Break(); Do let me know if it helps.. Cheers, Rahul I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

I might be wrong, but why don't you call a javascript function on keypress of the textbox and pick up the text entered in the textbox and upon finding the "." character, replace it with the desired character and put the text back in the textbox. Cheers, Rahul I do not understand what I do. For what I want to do I do not do, but what I hate I do. - Romans 7:15

Hello Ion888, This is a fairly easy thing, if I am not mistaken. If you want to do this in asp and access, I would assume that you know about adovbs.inc, global.asa files. Also you can create a common.asp file, where you can put all your database connectivity code, etc.. You can include the adovbs.inc file here.. For example: Dim cn : Set cn = Server.CreateObject("ADODB.Connection") '------------------------------- ' Create database connection string, login and password variables '------------------------------- Dim strConn, strLogin, strPassword strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=physical path of the database;Persist Security Info=False" strLogin = "login" strPassword = "pass" '------------------------------- ' Open the connection '------------------------------- cn.open strConn, strLogin, strPassword Then in your asp page, include the common.asp and then from the search string supplied in the textbox, do a select * from the necessary table and load the data in a recordset... Loop through the recordset and display the titles and other details as rows on the results page. Keep the titles as links pointing to another page, where you will show details of the clicked product. Pass the movie id as querystring to the details page, when any user clicks on the links. On the details page, based on the movie id from the querystring, do another select * from movie table for that movie id and voila you have a recordset with only that movie details. Loop through and show the details.. For more information, I think a simple search on google, or google groups would do the work. Investing in a good asp book would also help. Also this site can help a lot http://www.4guysfromrolla.com/[^] Cheers and happy coding, Rahul I do not understand what I do. For what I want to do I do not do, but what I hate I do. Romans 7:15

FranzKlein wrote: I found this website via DDJ that has free ebooks and html books. http://www.tcfb.com/freetechbooks/index.html\[^\] Anybody know of any other sites like this? Hi Franz, Here is one I found http://www.intelinfo.com/free_computer_books.html[^] Rahul

Written on a gravestone: Here lies a father of 29. He could have had more but he didn't have the time!

ArmenB wrote: Once that is done, the user should be able to choose a table and cut it into more rows or tables. What I wonder is, what exactly does the user choose here? The entire table, or just some cells from the table? And do you propose to allow the user to create seperate multiple tables or just one single table made up of various inner tables? Written on a gravestone: Here lies a father of 29. He could have had more but he didn't have the time!

Try this date validation script, I found on the net /** * DHTML date validation script for dd/mm/yyyy. Courtesy of SmartWebby.com (http://www.smartwebby.com/dhtml/) */ // Declaring valid date character, minimum year and maximum year var dtCh= "/"; var minYear=1900; var maxYear=2100; function isInteger(s){ var i; for (i = 0; i < s.length; i++){ // Check that current character is number. var c = s.charAt(i); if (((c < "0") || (c > "9"))) return false; } // All characters are numbers. return true; } function stripCharsInBag(s, bag){ var i; var returnString = ""; // Search through string's characters one by one. // If character is not in bag, append to returnString. for (i = 0; i < s.length; i++){ var c = s.charAt(i); if (bag.indexOf(c) == -1) returnString += c; } return returnString; } function daysInFebruary (year){ // February has 29 days in any year evenly divisible by four, // EXCEPT for centurial years which are not also divisible by 400. return (((year % 4 == 0) && ( (!(year % 100 == 0)) || (year % 400 == 0))) ? 29 : 28 ); } function DaysArray(n) { for (var i = 1; i <= n; i++) { this[i] = 31 if (i==4 || i==6 || i==9 || i==11) {this[i] = 30} if (i==2) {this[i] = 29} } return this } function isDate(dtStr){ var daysInMonth = DaysArray(12) var pos1=dtStr.indexOf(dtCh) var pos2=dtStr.indexOf(dtCh,pos1+1) var strDay=dtStr.substring(0,pos1) var strMonth=dtStr.substring(pos1+1,pos2) var strYear=dtStr.substring(pos2+1) strYr=strYear if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1) if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1) for (var i = 1; i <= 3; i++) { if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1) } month=parseInt(strMonth) day=parseInt(strDay) year=parseInt(strYr) if (pos1==-1 || pos2==-1){ alert("The Delivery Date format should be : dd/mm/yyyy") return false } if (strMonth.length<1 || month<1 || month>12){ alert("Please enter a valid Delivery Month") return false } if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){ alert("Please enter a valid Delivery Day") return false } if (strYear.length != 4 || year==0 || yearmaxYear){ alert("Please enter a valid 4 digit Delivery Year between "+minYear+" and "+maxYear) return false } if (

Try this: (Note: Change the 6 in the first "for loop" with your total number of textboxes.) function fnCheck() { var strTextBoxName; for(var i=1;i<6;i++) { strTextBoxName = "serial" + i; for(var j=0;j

You can try this to open the window in full screen. window.open('page.html','','top=0,left=0,height=' + screen.availHeight + ',width=' + screen.availWidth); You can also try adding, subtracting some from the screen.availHeight, screen.availHeight etc to adjust your window as per your requirements. cheers :) Written on a gravestone: Hear lies a father of 29. He could have had more but he didn't have the time!

Ever tried using ? Its a floating frame, which you can put in your existing html page, pretty cool and you can tweak around with it a lot. cheers :) Written on a gravestone: Hear lies a father of 29. He could have had more but he didn't have the time!

You can try this to always open the window in full screen. window.open('index.html','','top=0,left=0,height=' + screen.availHeight + ',width=' + screen.availWidth); cheers :) Written on a gravestone: Hear lies a father of 29. He could have had more but he didn't have the time!