hi, i 've table with orderid a foreign key to the ORDERS table, however, i forgotten to set ON DELETE CASADE while assigning the foreign key that time. Now how do i re set it? Is there any way out with SQL 2005 Studio Express? Or what kinda of Query Command should i type? I dunno how to Alter...
hi, i have a column a "text" type, i wish to let user input html tags into the column from a multi line textbox.
However, alot of " and ' chars are disturbing my insert sql statement. What do i have to do to store tags inside database? as in <> and </> etc..? do i need to do replace " all that...
I've a gridview which has
Hyperlinkfield in Second Column,
I'm trying to access the text property, but its returning null
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow...
How do i insert a sql and asp.net datetime functions and date now to come up with a sql statement to select data which are within now and 30days ago?
Any examples???
hi, i'ved created a membership page with asp.net (not with membership roles)
In my login.aspx
i've 2 textbox (password and username)and 1 button to login:
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid) {...
I've a database table with columns Description.
However i would only like to grab the first 20 words from the field, how do i go about doing it in ASP.NET with MSSQL ?
Any idea, algorithmn to share?
I've a database table with columns Description.
However i would only like to grab the first 20 words from the field, how do i go about doing it in ASP.NET with MSSQL ?
Any idea, algorithmn to share?
i'm totally new to php and mysql, i've use ASP before though with microsoft access db, odbc connection. I'ved tried installing the php windows installer to my winxp(with IIS) and then mysql server 4.3.1 everything installed
saw an example from the web, and decided to try out..
myphpfile.php...
hello, anyone can help me solve this problem??
my javascript is not working.... can't change the image when i click on the 1,2,3,4,5
See http://flyclassic.blogspot.com/
at the top right photo preview..
However, if i right click "show picture" , it can show the picture out, however if i click...
hi,
anybody has any idea to go about doing files uploading to the web server and also update the details to a mdb database file. I just need the idea, or any guides or useful resources to do it?
Let's say a user uses a form to upload abc.jpg file.
I would like to not only upload the file, but...
Hello, i hope guys up here can get help in this
i'm currently using MsAccess to create a database table
call StudentRecords one of the fields is a Date/Time type call "DOB"
which i set the format to be dd/mm/yyyy <-date of birth.
However i've problem retrieving records using SQL...
hi,
let's say i've a string call "19/03/1964"
anyone has an example on how do i make use of dateformat or date to calculate the age based on today's date?
Your help will be greated appreciated. thanks
hi, i'm doing a project with java updating a msaccess database. before going into updating database with sql , i need to validate the string input by user,
i need some help on how do i valid a string input by a user(jtextfield). The string is suppose to be a date to be entered. and following...
hi, my scenario is like this, please help..
Mine is doing a Database project
I've A JPanel which contains a JTabbedPane,
My JTabbedPane(has JPanel of Find/addUpdate/delete/(contain all the JTextField so that when record is a found, it is displayed in the JTextField)
And Also /View All Records/...
May i know how can i abstract every data from all the rows under a specific column?
When i use this SQL query statemnt, "SELECT Name FROM StudentRecord", this will return ROWS of record under the column "Name". So if i want to store every data into a variable, how can i do...
Hi, i would like to ask..
I'm using a cable connection.
I'm using windows xp, and i've set my IIS to PORT : 8899
to allow my friend from the internet to view my website,
i give him http://myip:8899/mappedfolder/
but it doesn't work, it is not accessible at all. Is it that there is any security...
Hi, I've this current script(ASP) that need modification which i've stucked.
My current script work this way, whenever my webpage starts it will go into a specific folder and search for extention ".xml" files and will list them out in a drop down list.
<%
Private Function...
Hi,
I would like to ask i've a variable string which i would like to write a checking statement
I would like to check if the string contain certain words before i process any other function.Let's say How do i check. Let say i would like to check if a string contains ":\"
from a string??
Hi, I would like to ask how to display an image with XSL from a xml file which content the tag
<image1>abc.gif</image1>
i know about
<image><xsl:attribute name="src"><xsl:value-of select="//image1"/></xsl:attribute></image>
but can i do any conditional statement to display...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.