|
Seems like everybody has SQL Server as a per month add-on plus setup. I'm used to the linux world of web hosting where you get a MySQL database already available and configured with no setup fees. To me that is a value, but I suppose that is asking too much in the realm of windows where there are licenses involved.
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
perlmunger wrote:
I suppose that is asking too much in the realm of windows where there are licenses involved
Absolutely. If it were free then the cost of the licence would be split across all users. Why should I pay for your SQL Server if I only need Access?
Brinkster used to offer 10Mb of SQL Server as part of the package and loads of people complained, so they split it off.
Paul
Pleasently caving in, I come undone - Queens of the Stone Age, No One Knows
|
|
|
|
|
I guess it makes sense. I'm spoiled in the sense that I've used free software so long that I expect a lot for nothing. On the other hand, I am pretty dang tired of not having stored procedures, sub-selects, and transactions in MySQL. So I guess what I was paying for from MySQL was nothing except a simple data store. I suppose the adage is true in this case as well--you get what you pay for. It's probably time to pony up. Argh!!
-Matt
------------------------------------------
The 3 great virtues of a programmer:
Laziness, Impatience, and Hubris.
--Larry Wall
|
|
|
|
|
I want to be able to swap items betwen two list boxes using JavaScript. It's a bit like a web version of the "Select recipients" window in outlook express when you can add people to different list boxes such as "To", "CC", "BCC".
+-----+ [ + Add ] +-----+
| | | |
| | | |
| | | |
| | | |
| | | |
+-----+ [ - Remove] +-----+
Add and Remove are just simple buttons that call some JavaScript when pressed. Also when an item is added to one list box it should be deleted from the other.
I know of loads of code to do this in MFC (I think there's an example on this site), but anyone got any pointers on how I'd do it in JavaScript please? I can work it out, but it would be nice if some nice person helped me and saved me a bit of time!
I feel like I'm diagonally parked in a parallel universe
Jeremy Davis
http://www.astad.org http://www.jvf.co.uk
|
|
|
|
|
Here are some things that I have found out by trial and error about using JavaScript with the HTML <select> element:
To access the <select>:
document.formName.selectName
To clear all of the <option>'s from the <select>:
document.formName.selectName.options.length = 0;
To add an <option> to a <select>:
var newOption = document.createElement("OPTION");
document.formName.selectName.options.add(newOption);
To remove an <option> from a <select>:
document.formName.selectName.options[i] = null;
To deselect <option>(s) in a <select>:
document.formName.selectName.selectedIndex = -1;
This should give you the basics to run with this ... and I am sure there is plenty of examples out there ... just don't have a link handy.
Wally Atkins Newport News, VA, USA
|
|
|
|
|
here's a couple of functions i wrote to do this.
function moveListItem(eleFrom, eleTo)
{
var i = 0;
var IDX = 0;
var arrMovIDX = new Array();
var startIDX = 0;
var arrRemIDX = new Array();
for(i = 0; i < eleFrom.options.length; i++)
{
if(eleFrom.options[i].selected)
{
arrMovIDX[IDX] = eleFrom.options[i];
arrRemIDX[IDX] = i;
IDX += 1;
}
}
startIDX = eleTo.options.length;
for(i = 0; i < arrMovIDX.length; i++)
{
eleTo.options.length += 1;
eleTo.options[startIDX].text = arrMovIDX[i].text;
eleTo.options[startIDX].value = arrMovIDX[i].value;
startIDX += 1;
}
for(i = eleFrom.options.length - 1; i > -1; i--)
{
if(eleFrom.options[i].selected)
{
eleFrom.options[i] = null;
}
}
}
function moveAllListItems(eleFrom, eleTo)
{
var i = 0;
for(i = 0; i < eleFrom.options.length; i++)
{
eleFrom.options[i].selected = true;
}
moveListItem(eleFrom, eleTo);
}
basically just create your buttons and add the appropriate function call to the appropriate button.
e.g. to move from left to right you would call "moveListItem(formname.leftList, formname.rightList);"
moveListItem will move only selected items (supports multiple selections)
moveAllListItems does exactly that.. it will move all the options from one list to another.
if you have any trouble implementing these the give me a shout and i'll provide an example.
HTH
|
|
|
|
|
|
|
Can I put a "Search the Website" facility on ASP pages and the search box page being used as an include file on rest of the website.
Please help and also if its possible, can you guide how it can be done?
|
|
|
|
|
|
Hi,
I have some code on a closing page of my ASP app...
Session("email") = ""
Session.Abandon
A previous page has this code:
email = Session("email")
emailExists = (email <> "")
if not emailExists then
Response.Redirect GetHomeUrl
end if
What I'm finding is that this works fine on my local PC web server (NT4 IIS). That is, if the user clicks "Back" in the browser they are taken to the home page.
But when I upload the pages to the production server (also NT4 but not under my control) this code no longer works. The email still exists. Why?
Kevin
|
|
|
|
|
I haven't got to the bottom of this problem. But, anyway, what I've now done is redirect the user to the home page after a specified time interval. The key thing is that when a user tries to return to the initial page through the browser history they won't be able to.
Kevin
|
|
|
|
|
In a C# project I have added a web reference to services on an external server. Calling on certain methods expected to return data containing one or more arrays gives an invalid cast exception and the error message read "Object cannot be stored in an array of this type.". From what I can tell I only get the exception when an array in the received xml-structure is empty (or null), but calling another method on the same service that returns an empty array goes just fine. According to the implementer of the service there is no difference in how the two methods returns data. I have also tried this in VB.NET with the same result. What can I do? What might cause the exception? How can I solve it/go around it?
Anything that may solve my problem would be most welcome!
/EnkelIk
|
|
|
|
|
Woops I forgot an important little detail: the service side is running Axis 1.0, whereas I use Microsoft SOAP Toolkit 3.0.
|
|
|
|
|
Turns out the returned data was not the same after all.
The data that did not work returned:
xsi:type="soapenc:Array" soapenc:arrayType="ns3:ErrorObject[0]"
And the data that did work:
xsi:type="soapenc:Array" xsi:nil="true"
|
|
|
|
|
Hi, i am building this page that reads a name from SQL server. The name can contain whitespaces, for example:
"Senior Process Reengineering Consultant"
And naturally, the character string will be truncated at the first whitespace. How can I get around this?
Thanks!
norm
|
|
|
|
|
Why is natural that the character string is truncated at the first whitespace?
What exactly are you try to do (elaborate please)?
Wally Atkins Newport News, VA, USA
|
|
|
|
|
Thanks, I solved it already: just put single quote around the string.
what exactly am i trying to do? well, i have this HTML textbox. Data comes from a SQL server and data can contain string with whitespaces. The string is "automatically" truncated when loaded into the textboxes.
anyway, problem solved and case closed.
norm
|
|
|
|
|
Hi all
I have some problem with ASP script.
If someone can help me to point out what I am doing wrong.
Below you can see the code.
It works as follow:
When one click on "Add a customer" button with all fields filled with text, alert
dialogs appear with the text filled in the field and it seems to work fine.
Then I try to open a mySQL database and insert a row with data.
But the alert dialog with text "New customer inserted" never pops up which means
that there is some syntax problem with the statement to open and insert inta
the database. Kan some trace out what is wrong with these line of code.
I have one more question:
As you see that my "myfunction" is written and called in Javascript language.
What changes do I need if the same code for "myfunction" is written in VB and
how to call when "Add a customer" is pressed?
Thanks in advance for your help
regards
/rsasalm
<%@ LANGUAGE="VBSCRIPT" %>
<title>init.asp
Register a new customer
Namn: | | Email: | | Telefonnummer: | | Rabattgroup: |
professional
Student
unemployed
| Password: | |
|
|
|
|
|
The code that you showed above is all client-side script. ASP is server-side script.
Try this:
First remove all of the javascript from your page (because it's really not doing anything that you want it to do).
Second, under <%@ LANGUAGE="VBSCRIPT" %> insert this:
<%
Sub myfunction()
Dim name, email, tel, rabbid, pword, DBConn
name = Request.Form("Name")
email = Request.Form("Email")
tel = Request.Form("Telefon")
rabbid = Request.Form("Rabbid") 'Put a name in for the select in your HTML
pword = Request.Form("Password")
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open("Shop")
DBConn.Execute("insert into tblcustomer values (1,'" & name & "','" & email & "','" & tel & "'," & rabbid & ",'" & pword & "')")
DBConn.Close
Set DBConn = Nothing
End Sub
If Request.Form("B1") = "Add a customer" Then
myfunction()
Response.Write("New Customer Inserted!")
Response.End
End If
%>
Hopefully this will get you on your way.
Wally Atkins Newport News, VA, USA
|
|
|
|
|
Can anyone explain to me the concept behind tab controls w/ internet explorer. I can handle them in c++ and would like to put them on my website only I have no I idea where to start. I know some HTML and CSS but no scripting languages. I just need a pointing in the right direction, general concepts, etc...Thanks.
|
|
|
|
|
There are actually plenty of ways that you could go about implementing tabs on a web page but it really depends on what you want to accomplish ...
If you just want tabs on your page and you don't really want to learn everything it takes to make them then you could use one that has already been created and shared like the one at WebFX[^].
If you want to dive in and make your own tabs you could use one of these ideas:
FRAMES - should be rather compatable with all browsers. Use the top frame to display the tabs and when one is clicked you change the content in the lower frame.
DIVS - use the CSS attribute display to switch between content when tabs are clicked ... this way all the content can be loaded at once.
I'm sure there are tons of ways to do this ... let me know if you would like further information on any of these ideas.
Wally Atkins Newport News, VA, USA
|
|
|
|
|
Hi,
I am developing a project in .NET (C#). I am trying to embed the email sending service in my project. I am able to send both plain and html formatted emails. But i m stuck in trying to get my style sheets and other flashy stuff appear in my html email. Can anyone tell me why my stylesheets and user controls just dont show up in the mail.
I would appreciate if anyone can come up with some suggestions,
Thanx.
Moinuddin
|
|
|
|
|
It's possible items are being stripped out of the e-mail ... can you view the source sent in the e-mail and compare with an original ... somehow ... and check for any obvious differences?
Other than that ... how is the CSS included in the HTML
As a reference:
<link rel="StyleSheet" href="stylesheet.css" type="text/css"> Or an attribute:
<p style="border: 1px solid black;">Message Text</p> If it's a reference it needs to be absolute for it to work in the e-mail.
|
|
|
|
|
Hi Moinuddin,
I think when you draft content that is being assigned to the body property of the mail object, you need to fully qualify the path of the StyleSheet file, with your servername, like http://www.yourservername/yourapp/scripts/style/style.css etc.
Otherwise, you may also copy the required styles inline into the body attribute and proceed.
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|