Hi,
I am aware of this question already existing, but it has given me no luck.
I have an application which loads a physicial XML document via the following method:
jQuery.ajax( {
type: "GET",
url: fileName,
dataType: "xml",
success: function(data) {
etc...
I parse the XML and convert it into a string which is saved into a variable so that it can easily be stored in a database. How can I now convert the data in this variable back into an XML object so that it can be parsed as such?
Hi everybody,
I am kind of new to mySQL:s union functions, at least when doing inserts with them. I have gotten the following to work based upon a example found on the net:
INSERT INTO tableOne(a, b)
SELECT a, $var FROM tableOne
WHERE b = $var2
UNION ALL SELECT $var,$var
Ok, nothing strange about that. But what happens when I want to insert a third value into the database that has nothing to do with the logic of the Select being done?
Like : INSERT INTO tableOne(a, b, c )
How could that be done?
I've got a datagridview that is databound from a database table. How do I:
a) Edit the displayed value for a column using the values from other columns in the row? (For example, display a URL like:
<a href="/url?param=columnA">columnB</a>
where columnA is the value from column A and columnB is the value from columnB)
b) Add an additional column using values from the other columns (similar to a.)
I strongly prefer not to use additional 3rd party components, libraries or DLLs (at least in v1.0), unless there is absolutely no other solution.
Question: (how) can I use Delphi to programatically crate a BDE database and write to it, then use PHP to read from it?
Any URLs for examples of tutorial?
we have a portal that have SQL server 2005 database that contain about 1750 stored procedures , 250 view and 200 function and 95% of them not have handling exception in their code .. we search about any way that allow us making such a global exception handling in SQL that receive any exception happen in any SP,view or function and stored it in a table we made .. is there something like this in SQL server 2005 or we must write exception handling code on each item ?
Good day,
I have an application written using the Symfony framework. The application works on my development server, where I have shell access. However, I am unable to load my application on my host, as I need to run symfony doctrine::build on the command line on the host.
Is there another way to load the database after or during symfony project:deploy?
I've discovered PARSENAME function as a good choice to order IP address stored in Database. Here there is an example.
My issue is I'm using Hibernate with named queries in a xml mapping file and I am trying to avoid the use of
session.createSQLQuery(..)
function.
I'm wondering if exists any PARSENAME equivalent function for HQL queries. I'm searching for it and cannot find anything.
Many thanks.
I've an access database table with 3 fields :
Purchase date
Warranty time
Warranty expiry
Warranty time has 1, 2, 3, 4, 5 in it which corresponds to years.
How can I auto-populate the 'Warranty expiry' field (which is a date field) by looking at the 'Purchase date' and then adding on the 'Warranty time' (warranty time will be 1 = 365 days, 2 = 730 days, etc)?
Hello,
I'm trying to insert in an Access Database, from visual C#. But i got this error: error
What am I doing wrong in code? The values are correct, they comes from the input boxes.
Thanks!
Is there a quick and easy way to backup both MS SQL 2008 and MySQL, all their databases?
Right now I have a batch script that runs, but I have to manually add a database each and every time, and I'm sick of maintaining it. So I want to set it up to backup all MS SQL and then all MySQL, I dont care if its two different solutions, just want the ability to backup all the databases without having to type them in.
Thank you.
Hi,
in my Django (1.2) project, I want to prepopulate a field in a modelform, but my new value is ignored.
This is the snippet:
class ArtefactForm(ModelForm):
material = CharField(widget=AutoCompleteWidget('material', force_selection=False))
def __init__(self, *args, **kwargs):
super(ArtefactForm, self).__init__(*args, **kwargs)
self.fields['material'].initial = 'Test'
I also tried with self.base_fields, but no effect: there is always the database-value displaying in the form. Any ideas?
I have 3 database tables:
article
article_has_tag (2 FK's to the other tables)
tag
I currently show a list of articles with the article's tags shown underneath but the number of queries grows as the list gets longer.
I want to loop over all the articles and get the tag objects from each one in turn.
Can it be done in 1 propel query?
I'm syncing the Google Calendar with my application (I store events in a database). When an event is updated I can easily find the last updates by sorting the event feed on the 'updated' order.
However, if an event is removed / deleted, how can I track this update from the feed?
i still , don't understand , how wordpress can understand what is this url refer to :
www.mysite.com/about-me/
they are using no identifier
if they using slug functions so how they can retain story information or in other word , how they change back the slugged title to select from database
Hello, I have just started learning Haskell and have got stumped on how to add a rating to a custom data type.
The data type I'm using has a name, a year and a tuple (userName and their rating), it looks like:
data Wine = Wine String Int [Rating] deriving (Eq,Ord,Show,Read)
type Rating = (String, Int)
I wanted to allow a user to rate a given wine from a database, stored as [Wine] but cant figure out how to to it. Any pointers or suggestions would be greatly appreciated! Thanks.
I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes.
So is there any script in php or anything that can allow to do so unlike phpmyadmin ?
I'm taking values from a database and dynamically placing points on a 2d cartesian plane. I need a way to set the top and left css properties.
Any help would be much appreciated.
Thanks in advance
Which is a better choice on a development box if you primarily develop Asp.Net applications and SSRS reports. I have never had to use the Express editions, so I don't really know the pros or cons.
The cons I have listed for Standard+ editions are:
toll it takes on system resources
pain to attach database for projects
pain to detach unused databases
$$$
Pros:
You have everything you need
Management Studio features
Easy move to production
i have this querystring that shall open up my page.
http://www.a1-one.com/[email protected]&stuid=123456
Now when this page loads, on page_load, I want to pick up email and stuid in two different variables. So I can use them to insert into my database (sql server)
how can this be done in vb.net
The prevailing wisdom in webservices/web requests in general is to design your api such that you use as few requests as possible, and that each request returns therefore as much data as is needed
In database design, the accepted wisdom is to design your queries to minimise size over the network, as opposed to minimizing the number of queries.
They are both remote calls, so what gives?
Hi,
I know that there are few open sourced / Free BI projects and I am looking recommendations.
I have a growing Mysql database that i got tired from writing sql queries + gui + filtering over and over again.
if i am not able to find a free one than my budget will be: (1$ - 2500$ )
My needs are:
Mysql 5 Connection.
user permissions
export options
Basic Dashboard
--
nice to have:
Web Based GUI
Development framework integration in PHP
I have a table of over 150,000 rows of which most would be updated daily. I have mysql caching turned on so the pages load faster however everytime the database is updated the pages load slow again, which I assume is the cache building itself again.
So at the moment I have resorted to doing a wget -m --delete-after http://localhost/ on the server however this takes about 4 hours to complete and moves something like 13 gig.
Is there a better way to do this?
I want to display list of objects from database, and on the same page have option to edit them. When submitting, I'd like to submit changes to all of them.
I found this link: http://haacked.com/archive/2008/10/23/model-binding-to-a-list.aspx and http://www.hanselman.com/blog/ASPNETWireFormatForModelBindingToArraysListsCollectionsDictionaries.aspx but there is no description how to handle posted data in controller.
Thanks in advance!