I don-t know how to use one table from one database and second table from another databse at the same time or copy data from table in one database to table from another databse.
I tried following query:
select * into NewTable from existingdb.dbo.existingTable;
But it doesnt't work.
Hi i need with jQuery to change data in input field when user click on some link
<input value="height-size-width">
so when user click on some
<a href
link with width id script need to change only widht in input field.... if user click on height a href link script need to change only height in input field...
Like youtube embed option
Any help?
how do i organize country data (countries, states and cities etc) in mysql?
cause every country has 3 tables: countries, states and cities.
should i have each country in separate set of tables or should i have them all in these 3 tables? if i have all of them in same tables, im afraid that the amount of rows will be huge cause i tend to have a lot of countries!
what is best practice for this?
Hi,
I'm trying to practice my programming. What sort of projects would be helpful to try implimenting real life usage of various data structures?
Thanks,
SEC
Hi,
I have a J2ME application - which generates XML data (from an object) and needs to get it sent across to a remote server/machine. How do I get this xml or the object through to the remote server please? Thanks. Just in case it might help, the receiving application on the remote server is PHP powered. Thanks again.
I have 3 tables, with 3 fields all the same. I basically want to select information from each table
For example:
userid = 1
I want to select data from all 3 tables, where userid = 1
I am currently using:
SELECT r.*,
p.*,
l.*
FROM random r
LEFT JOIN pandom p ON r.userid = p.userid
LEFT JOIN landom l ON l.userid = r.userid
WHERE r.userid = '1'
LIMIT 0, 30
But it doesn't seem to work.
I am looking to dynamically load javascript that has been parsed as PHP so that I will be able to pass PHP variables to javascript, and then load this file into the primary PHP document. I have a document called myscript.js.php that includes the javascript and PHP. I attempted to load it into the primary document using jQuery's getScript like this:
$.getScript("myscript.js.php", function() {
alert('loaded script.');
});
This attempt failed - I am assuming because of the .php extension on the file. Is there anyway to dynamically load javascript that includes PHP? I have a few session variables that I am looking to pass through javascript that will be updated frequently, creating a need for the javascript to be reloaded.
I have CMS table that contain CMS_STARTTIME and CMS_STOPTIME (attachment).
I want to create report to summarize exist data by using Date, Time and Year as Parameter (attachment).
I don't know how to create sql statement to meet this requirement. I'm using MySQL and MS-SQL.
Does one can help?
Thank you very much.
Hi, I'm wondering how I can sort mysql data based on the number of entries.
I'm doing this so I can have a page of the top purchases, so it would have to retrieve all the product_id's from a table, and then sort them by the most times one shows up, limiting it to 10 or something.
Thanks!
I have a view in which there is a text box where user enters data, when clicks on submit, I want to store the input and display in another box.
final EditText edittext = (EditText) findViewById(R.id.edittext);
mText = (TextView) findViewById(R.id.timepicker_input);
How can I do it, please help
I came across a case where I have to convert html table data into json. In this process I have to iterate through table and convert one by one(row) into array and then convert the whole array into json? Need help in iterating through table(each ow and column)?
I am having a data list that shows images and button under it. Now i want to download that images. I have written code for that. The problem is i want to access the image on click of button. How it can be done
In an class header I have seen something like this:
enum {
kAudioSessionProperty_PreferredHardwareSampleRate = 'hwsr', // Float64
kAudioSessionProperty_PreferredHardwareIOBufferDuration = 'iobd' // Float32
};
Now I wonder what data type such an kAudioSessionProperty_PreferredHardwareSampleRate actually is?
I mean this looks like plain old C, but in Objective-C I would write @"hwsr" if I wanted to make it a string.
I want to pass such an "constant" or "enum thing" as argument to an method.
When you use meshgrid to plot data (using meshgrid itself not one of the other plotting functions), how do you change the color to grayscale or black and white? Also, how do you get rid of the "meshy" look of the image?
hi,
I'm using a custom component CheckBoxList DataGrid (http://blogs.adobe.com/aharui/2008/02/checkbox_selection_in_datagrid.html) and as dataProvider I have an ArrayCollection with items such this one:
name="item name" selected="true"
I would like the CheckBox list updated when the selected attribute is set to false or true in the data model.
thanks
Hi!
I´m trying to write a log system for my CakePHP intranet. What i need is to store de username/datetime whene someone tryes to login.
My login code is on the clients_controller and i need to store the data on a model called log (i have the model, controller, view... but they are not related)
how can i achive that?
thank you
i am using Docmd.TransferText to import data from a text file into my access table.
i would like it to do the following:
if the record already exists, then update it
if the record does not exist then add it
how do i accomplish this?
currently i have this line:
DoCmd.TransferText acImportDelim, yesyes, "table3", "C:\requisition_data_dump.txt", True
table1 has column CITY and COUNTRY. table2 has column CITY.
how do i delete from table2 all records that have CITY in common with table1 but also the COUNTRY='Russia' ??
please keep in mind that both tables have about 1 million rows of data
Hello
I want to use XQuery on a column of data type NTEXT (I have no choice!). I have tried converting the column to XML using CONVERT but it gives the error:
Incorrect syntax near the keyword 'CONVERT'.
Here's the query
SELECT
y.item.value('@UserID', 'varchar(50)') AS UnitID,
y.item.value('@ListingID', 'varchar(100)') AS @ListingID
FROM
dbo.KB_XMod_Modules
CROSS APPLY
CONVERT(xml, instancedata).nodes('//instance') AS y(item)
(instancedata is my column)
Can anyone think of a work around for this ?
Thanks
I've noticed that in recent versions of Firefox, some images are displayed even when I disable images (e.g., Google News). Apparently this is due to images being embedded in the code using the "data:image" specification. Does anyone know of a way to disable these images from being displayed?
Thanks.
I'm writing a little application for my BlackBerry and I need to send some data to a webpage (Via GET or POST)
Can anyone advise on the way to do this with the BlackBerry.
Hello, i have a table and i want the data from the cells to be printed onto a input field when i click the a specific table cell using the "onclick" command. i was thinking about getdocumentbyid or something like that
greet
I want to update Table2 names with names from Table1 with matching Ids
I have around 100 rows in each table.
Here is my sample tables.
Table1
ID
Name
Table2
ID
Name
Sample data
Table1
ID |Name
--------
1 |abc
2 |bcd
Table2
ID |Name
--------
1 |xyz
2 |OOS
Expected result
Table2
ID |Name
--------
1 |abc
2 |bcd
How can I do this?