I'm trying to use ADO to create several tables at once, into MS Access. Is it possible to do multiple statements in the one operation? For instance: ... // I have omitted the field details CString sQuery = "CREATE TABLE [Table1] (..., PRIMARY KEY ([ID])); \nCREATE TABLE [Table2] (..., PRIMARY KEY ([ID]));"; oRecordset.Open(oDatabase.m_...
We are currently working in a team where we use both Visual Studio and Code::Blocks, is there a way to replicate changes between those project files? So if one adds a file to the project file it will also get adjusted in the project file of the other IDE? Please note: We want our project to work on multiple IDE's, platforms and compiler...
Hello, If one of my processes open a file, let's say for reading only, does the O.S guarantee that no other process will write on it as I'm reading, maybe leaving the reading process with first part of the old file version, and second part of the newer file version, making data integrity questionable? I am not talking about pipes which...
I would like to write a PHP function that calls another function Page 1. User selects item from drop down. (I then post to the same page.) Page 1. (I have a query on the page that's based off of which item is selected) (In this case I'm returning the lat and long of the item.) $latitude = $row_farms['lat']; $longitude = $row_farms['...
We are using XML to define a schema for controlling the contents which can be displayed in a diagramming tool. The schema file specifies what kinds of object can be placed on the diagram, how they can be linked together, and what properties these objects have (that is, what settable properties apper in the editor). When a new kind of di...
Hi, I have: http://www.one.com and http://www.one.com/uk www.one.com is the main site, but there is a UK version of this site which ideally needs to be in a subdirectory (/uk). How do set IIS up to allow me to have multiple sites under one domain? Or can I have two separate sites and use ISAPI_rewrite to point www.one.com/uk to r...
I have a single file and need to serialize multiple objects of the same class when ever a new object is created. I can't store them in arrays as I need to serialize them the instance an object is create. Please, help me. ...
HI, New to StackOverflow... I am using SQLite in an application that I am developing. I am trying to run a pretty complex query (complex for me!!) and I have gotten the basic results i need but I am stuck on getting over the last hurdle. I presently have this query that does what i need it to do... SELECT SUM(activity) FROM activitie...
Context Let`s say i have: In layout Site.Master: <div class="leftColumn"> <asp:ContentPlaceHolder ID="MainContent" runat="server" /> </div> <div class="rightColumn"> <% Html.RenderPartial("_Login"); %> <asp:ContentPlaceHolder ID="SideContent" runat="server" /> </div> Login partialView looks like: <form action="/myApp/...
ok so heres the scenario: i got a blog on the root directory of my host then i hosted some app on a subfolder named fsGallery. now, i bought a new domain for my blog and another domain for my app. ii would like to know the proper htaccess 301 redirects in order for me to redirect the old directories to their respective new domains here...
I have an autocomplete field and am just wondering how can i use it for multiple words? When i type the first word it works perfect, but when i space and type in the second word, its sends the two words back to the server and of course the results are wrong! eg. when i type the two words, 'Java javascript' the first word 'Java', autoc...
I have a comparison I'd like to make more efficient in SQL. The input field (fldInputField) is a comma separated list of "1,3,4,5" The database has a field (fldRoleList) which contains "1,2,3,4,5,6,7,8" So, for the first occurrence of fldInputField within fldRoleList, tell us which value it was. Is there a way to achieve the followin...
I have 2 click handlers binded to an element like so: in the file which contains the control I am binding to, I have the first handler, which does some functionality specific to that control $("#mycontrol").live("click", function() { alert("foo"); }); In the main page which uses that control, I have another handler binding to that el...
I want to take several iphone projects that I wrote and combine them into one project. What's the easiest way to do this? I would like it if I could access all these projects from one button on the iphone home screen. ...
I'm trying to solve pretty easy problem. I want to establish connection to 2 totally different databases ( but both mysql ). Now I tried to solve this by creating multiple config files and then creating multiple sessions. Everything works until I reached relations. I have 2 tables in 2 databases: db1 - News db2 - News_Authors I add...
I have a multiple select element when i tried to aligned the options to the right i can't , and i searched the web for many articles but i failed to find the solution at last ...
I know in SQL Server this is possible using linked servers. Is there some analogous way to do this in mySQL? Thanks! ...
I'm having so many problems getting more than 1 MVC project up and running on the same server... I'm using a Windows XP system running the default IIS (5.1 I believe). At this moment I'm even building WebSetup projects for every project I create to make sure everything goes well, while these projects could very easily be deployed using ...
Hi there, I am making a prompt in C# that instructs the user how to use the program before they can access it. What is the best way to display multiple lines of static text? Using a bunch labels doesn't seem like it would be the proper way... xD ...
So m.SourceCollection has 1000 records going into this, which is a collection of items with a Lat and Lon property; nothing else. I run this: var results = from locs in m.PlacesBeen group locs by new {locs.Lat, locs.Lon } into myGroup select new { Lat = myGroup.K...