1,694 Topics
|
|
Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find … |
|
I am working on an ERP based project which was created using asp.net(3.0)c# as the front end and sql server(2005) as the back end. We have completed the project but after installation on the client location, when Multiple users Login and use the same form to perform a transaction, then … |
|
Hi there, since recently i have been trying to master HTML, and now i am full ready to take on PHP therefore, just like HTML instead of making many .html files | i want to use the PHP dynamic page function that can show me pages from database. usually as … |
|
Hey guys, I am writing a web application in asp.net using c sharp. I have a web page that lets the user create a program. In this system a program is made up of many applications and an Application can belong to many programs hence a many to many relationship. … |
|
|
this is the code to email confirm. The user clicks on the link in the email, passing the code through url to this page. Then the data is transferred from a tmp table to main one. I have queried in phpmyadmin and it works fine. But when i actually use … |
Hi everyone here, Can someone please guide me in transforming XML-to-SQL output with Python? I need to create 2 tables (Books and Patrons) into SQL. How much i suppose to start with??? <?xml version="1.0" ?> <Books> <Item> <BookID>A001</BookID> <Title>A Tale of Two Cities</Title> <Author>Charles Dickens</Author> <Language>English</Language> <Year>1859</Year> <Quantity>5</Quantity> </Item> <Item> … |
|
|
I'm trying to set up a simple little rating system for videos on a website. If you push + it adds 1 and if you push - it subtracts 1. I've got it working just fine. However, the way i'm checking to see if you've rated it already is by … |
|
I am building a website that hosts and streams videos. I am currently testing the site on my own server. I would like to host it remotely once it is going live. I am looking for a good and reliable hosting service that provides necessary resources for online video. The … |
Hello, I have developed a site in VB.Net and ASP.Net with a database backend that allows a user to enter a centre code and in return it retrieves all records from the datbase where the centre code matches the one provide in the text box. My list is appearing as … |
|
Okay so I've searched just about everywhere but can't seem to find what I'm looking for. I'm learning as I go with PHP and I'm having a problem figuring out what is wrong. I've got two different queries calling a group of information. Within each query is a field that … |
|
View the full tutorial at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] I have tested this many times and it works fine. Please don't complain unless you really can't get it working, Just PM me and I'll fill in the blanks Happy Coding :) |
|
I'm trying to connect a SQL database to a Classic ASP site. I keep getting the following error message no matter what I do: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. I have an ODBC entry for this database, as well as have the … |
|
[code]<% String UN=request.getParameter("un"); String pw=request.getParameter("pw"); String FN=request.getParameter("FN"); String LN=request.getParameter("LN"); String L1=request.getParameter("L1"); String L2=request.getParameter("L2"); String L3=request.getParameter("L3"); String ccn=request.getParameter("ccn"); Class.forName("com.mysql.jdbc.Driver").newInstance(); java.sql.Connection myConn; myConn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/train_resev","root", "3866" ); PreparedStatement ps=myConn.prepareStatement("insert into user values('" + un + "','" + pw + "','" + FN + "','" + LN + "','" + L1 + … |
|
|
Hello, i attempting to edit an online payment form to connect to MySQl, i have managed to get everyting working up until the payment page. The problem i am having is sending the cart contents via encrytion to the server. When there is one product, there are no issues. If … |
what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table. |
|
hi guys! i have a problem regarding the queries i coded. my first query is to display the category name, description and maxscore: SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category c ON g.cat_id = c.cat_id the problem is, i don't know how to delete the row in the … |
|
please tell me c# code i want to determine largest number in a column of sql server 2000 table and store it in a variable. |
|
I always get this error: "Error updating joke: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1" There's something about this part of my code that causes that error and … |
|
Hello, I am currently working on a stored procedure that shows the time of day as an integer value: 456, which means 4:56. I was wondering if there is a way in SQL that I can convert this int in to a datetime value. So instead of the time appearing … |
|
how do retrieve the last record if its id or other fields are unknown...or simply i need to move the record pointer to the last record in a table...thanx a lot... SELECT * from stud_infos WHERE stud_id = 'HOW DO I DO IT?' |
|
So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would … |
|
Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret … |
|
Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a … |
|
a browse and submit button when pick the image and submit , the image name goes to my SQL table and the image it self that the customer pick it copied to my "upload" folder :( my problem is that i only see the image name , so my issue … |
|
I am not sure I am under the write forum but here is my problem: I have a pretty simple program written that works just have a lot of repeated code and am not sure how to condense it in this situation. The program reads in table names from the … |
|
Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone … |
|
I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management … |
|
Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" … |
|
Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 … |
The End.