mikek12004
Last Activity: Jan 26 '10, 01:18 PM
Joined: Sep 8 '08
Location: Athens, Greece
-
How ot take backup the whole database with PHP?
I have a button "MysQl Backup" and I want when clicked to create a DB backup in a txt files (containing SQL commands) -
Indeed in the import object's forms tag I cannot select anything and I have only the mde....is there any other way? -
how do you do it? (both damaged and repaired are in Access 97, rarely use access so some pointers would be most helpful )
what do you mean by "R/O design"?...Leave a comment:
-
Getting the forms from one mde to another
Have an mde file with lots of tables/forms which became kinda corrupted. With a restoration utility created a 'repaired version' with all tables but it didn't transfer the forms, how to transfer them? -
Tried to put it directly in the <a> tag didn't do anything, haven't tried to put it through js but probably will have the same effect...Leave a comment:
-
I do not want to lose the previous page (think of it as a page of contents from which the user clicks various links)Leave a comment:
-
How can I make the document.formname.submit() to open in a new window?
Upon clicking on a link I want to go to another page with lots of data (which I do not wish to pass through GET so I used post like this)
the links is
and just aboveCode:<a onClick="display1(1)" onMouseOver="this.style.cursor='pointer'" class="a3" >click here</a>
...Code:<form name="f1" id="f1" method="post" action="http://127.0.0.1/dome/main.php?page=69">
-
query analyzer? I run it in the new query tab of SQL 2005 and it run in about 3 minsLeave a comment:
-
hmmm.....those spaces that appear when doing an echo is not present in the actual query (you can see it in the code) plus in the SQL server 2005 the query runs just fineLeave a comment:
-
how to get the data from a access 2002 application
I have a access 2002 application (a file with MDE extension) which when you execute it access 2002 opens and you insert/view/modify data through a series of user-created forms. Assuming that they are stored in a access database I want to get that database in order to create a new application (preferably with php/mysql). So I want to get the application's data. Anyway I could an export or something like that (even getting the data in access format... -
Doing a query through php to sql server 2005 and get query timeout
doing a (not so simple) query -which works fine in sql server using PDO like this:
...Code:// attempt a connection try { $pdo = new PDO("mssql:host=$hostname,1433;dbname=$dbname;",$username,$password); } catch (PDOException $e) { die("ERROR: Could not connect: " . $e->getMessage()); } // create and execute SELECT query $sql = "select datepart(week,(clroot.dochdsal.date1)) -
mikek12004 started a topic have a query with 4 selects in union and want to use count() and limit on the wholein MySQLhave a query with 4 selects in union and want to use count() and limit on the whole
with one query I would something like this
to get the number of results and thisCode:SELECT COUNT(id) AS numrows FROM pelates where owned='112';
to get the subset I need, but now I have a union of 4 selects and I want the count of the whole and the limit to be applied to the whole results also any ideas?Code:SELECT * FROM pelates where owned='122' LIMIT 10,20
-
mikek12004 started a topic Need an editor from which I can paste to MSWord and get also line numbersin GeneralNeed an editor from which I can paste to MSWord and get also line numbers
In a MSword document I want to paste code with line numbers (and command coloring if possible) in order to make the readability easier, any text editor you know for this? -
kinda tried that and got nowhere do you have a code example?Leave a comment:
-
Worked like this
At last I can continue, you cannot imagine how many hours I spent wondering why it is not working (I thought that the SQL view was identical to the mssql which I worked in sql studio since they are both from microsoft...)
Anyway thanks a lot both of you for your quick replys...Leave a comment:
-
Well...msquared 's solution got me an 3464 Error
topher23's Worked (with removing an extra parenthesis),
a new (better) new possible solution which saw and deals with all updates at once is
This is MSSQL code which worked perfect in SQL server '08 but in Access
made like this
got a 3144 Error any ideas?...Leave a comment:
-
Tried
got a "Syntax error in UPDATE statement" popoup and when I press help I seeCode:update DailySnapStocks set Date=#4/8/2009# where Date=#4/8/4009# and Symbol='FTSE'
"Syntax error in UPDATE statement. (Error 3144) "Leave a comment:
-
mikek12004 started a topic Cann't get values in a Date/Time column to increment by a set number of yearsin AccessCann't get values in a Date/Time column to increment by a set number of years
I have a column date with 'Date/Time' type which holds values like this
8/4/2009 for the 4th day of the 8th month of 2009, due to some bug many records write instead 8/4/4009 so I want for those record to put the write date. The whole thing is for a asp script so for there I could easily write a SQL query like
which didn't work...Code:update DailySnapStocks set Date='4/8/2009' where Date='4/8/4009' and Symbol='FTSE'
-
guess you mean using the <noscript> tag? or there is a better way, and do you know of any statistics of user having JS turned off I can use (found a couple on Google but want something I can put on my references)?Leave a comment:
No activity results to display
Leave a comment: