Posts by hericles

Hi,
Are you getting the booking info from the same database? Your SQL query could simply use a JOIN on the two tables (Customers and Bookings) as they both have customer_id as a column.
I couldn't see any location where you had tried to draw out the booking info though...
Hericles

Thanks, that makes it clearer. Your solution lies with JavaScript.
You'll need a script that takes the offset position (position from the left of the page) of the image and adds it's width; If the result is greater than the page width, shift the image to a new position.
This would need to be done for the height as well of course.
I haven't got anything like that to show you at the moment but a Google search should find something. If I fnd anything I'll let you know

Seeing you are using session sate you can cycle through the Pets list and save every checked option into an array and store that in the session state for retrivel on the results page. I'm assuming you need the summary on the results page to return a possible pets list of more than one value?

In the VS designer you have selected for the textbox to be AutoPostBack = True? Is the javascript code shown in red entered by yourself or auto generated by VS at compilation?

I'm confused too. The hover will appear over the thumbnail (although you can alter that with the left value in the .thumbnail:hover span section.
But if the image is on screen to hover over, the large pic will be on screen too...

Use session state. That'll hold the variable until the user ends the session or it times out.
To set it:
Session.Add(name, value)

To get it:
x = Session.Item(name)

Hope that helps,

LIghtBox, lightWindow etc are all Javascript tools. Check out the ProtoType or Scriptaculous javascript libraries or search for the lightbox code online. You're find some pretty good tutorials and examples.

You've got a couple of options. If the data in the able isn't very large and you're not worried about net traffic, draw the info back out of the database once its saved (thats all of the info) and databind the gridview to the dataset again. But that is lazy and wasteful.

Secnd option is to create a datarow object, add 3 columns to it, enter the textbox data to the relevant column and then add the row to the dataset. Databind the dataview again and it'll update with the new information. The gridview and the database will then match each other and you've avoided another round trip to the server.

Hope that helps,

Are you accessing the ToString() property of the textbox? If not, you're not working with the string value itself, you're trying to alter the TextBox control. Are you trying to subtract two numbers or are you working with text input?

What is the table structure you are using and are all 62 tables of the same design? Its hard to talk about efficiency without understanding how the tables are constructed.

OK, I'm confused. There is no 'Click here' link in your HTML, just a text box and the drop down list.
What is the text box meant to down when typed into? If the drop down list is populated, simply clicking on it will cause it to expand so items can be selected.

Can you be more specific as to the problem?

Hi,
KISS huh?
Question depends on the type of questions theyare answering although any solution requires saving the answers they've entered in some way. If its multi choice or short answer you could save each answer to a database under the user ID and then retrieve them when they log back. Or, if you're keen you could save the answers as XML files but the database solution is easier.

Setting up passwords isn't someting that can be explained in enough detail here. I suggest finding an article online and reading it.

By blocking copying I assume you mean disable printing and print screen and the like. To be honest I've never had to try it and I'm not sure a foolproof method exists. Maybe someone else has advice on that part of it.

Hope that helps,

I'm assuming the name is www.roommatefinder.com (or similar suffix) but you don't actually mention it. You mention the admin person getting confused with the 'double R' and there is no double R in that URL so I'm not even sure that's the right one.
If it is roommatefinder I don't see any real problem with it. Its easy to remember and uses normal spelling. You might consider including a '-' (to make it roommate-finder) but most people don't expect hyphens in URLs (my opinion at least).

Hope that helps,
Hericles

I have to agree, your problem seems obvious. You've turned it off by setting it to false.

Hi,
When you're generating your numbers use a SELECT CASE statement to decide which one of several string to append.
E.g. create the next number (i.e. 2) in a variable and check its length (1 in this case. Then use the select case to add the correct string to the front.
Example: (in VB.Net)
Dim student As Int
student = ' generate number by whatever means
Dim len As Int = student.Length()
Dim strNumber As String
Select Case len
Case 1
strNumber = "EFU00" & student 'for numbers 1-9
Case 2
strNumber = "EFU0" & student ' for numbers > 9
Case 3
strNumber = "EFU" & student ' for numbers > 99
End Select

Hope that helps, make as solved if so, thanks:)

Hi,
The truth is that the browsers all render the pages slightly differently. They are meant to adhere to the HTML specifications but most browsers will not follow the specs in exactly the same way. You should have been around 5 years ago, things were a mess...

For example the amount of padding that IE gives to a UL might be different than what FF does, hence a slightly different feel. You might want to have a look at the ACID2 test. Its a rendering test that browsers should pass to be considered standards compliant. The results are interesting...

Hope that helps,

Hi,
If you're drawing the data for the first two columns out of a database, just add a third column into the SQL query that combines the two. Then databind the gridview to the resulting table.

E.g.
Select exam1, exam2, SUM(exam1 + exam2) as total from table;

If you need to do it after the query for some reason, add a new column to the resulting dataTable from the query and then loop through inserting the sum of the two columns together. Then databind the gridview once that is done.

Check this article out for an example of the code:
http://www.codersource.net/dataset_preparing_manual_data_addition.html

Hope that helps,

Hi,
Pretty big topic to post here but I'll try to explain it in brief:

I'm guessing you want some event (a new yoga class being set up) to trigger the email part of the software. Thats simple enough, it can be user controlled or called when the new yoga class is saved, created, etc.

To send the emails you will want to pull all of the relevant users and their email address out of your database. Store this in a dataTable or similar.

For the emails you could choose to send an email to each person seperately (have one name in the To field when the user receives the email); to do this call the email sending method once for every name in the dataTable of users. This is pretty wasteful unless you have an idle server and load isn't an issue. You can personalise the email with this method i.e. use the person's name directly.

Option two is to concatenate all the user's emails into a string and call the email method once; all the users appear in the To field and you wouldn't be able to personalise the email.

The email method itself will need to import the System.Mail class (I think thats what its called) and set up the To, From, Message, etc parts of the email; and then send it. The MSDN library will have everything you need to set it up.

OK, thats the theory, hope it …

Hi,
The timer you can code up in JavaScript to run on the page. There's no need to use server-side code for that.

The changing sections without a page refresh will either require AJAX or, if you wanted to, you could conceiveably use plain JavaScript again to hide and disable sections of the page as the timer runs out and display the next one.

Hope that helps,

Hi,
I'm using a dataTable to process some data onto a webpage.
The Page_Load calls the sub that access the database and sets up a dataTable. Another sub is then called which processes the dataTable and outputs to the webpage. That all works fine.
I want to add a drop down list that has filter criteria in it. Depending on the filter selecte the dataTable is adjusted to display by name ascending, cost ascending etc.

The problem lies in the drop down list sub. A switch statement decides what the filter and sort expressions are to be based on the selected value of the list (again, this part works OK).
The problem occurs when the dataTable.Select method is called. I've debugged the code and the dataTable is empty at this point so a 'column not found' error results.

Private Sub ddlFilter_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlFilter.SelectedIndexChanged
Dim selected As Int16 = ddlFilter.SelectedValue
Dim strExp As String
Dim strSort As String
Select Case selected
Case 0

Case 1
strExp = "'cost' > 10"
strSort = "cost ASC"
Case 2
strExp = "duration > 1"
strSort = "duration ASC"
End Select
' create new dt, run filter and pass to displayDT sub
Dim dt2 As New DataTable
Dim drRows() As DataRow, singleRow As DataRow
dtRows = dt.Select(strExp, strSort)
// error occurs here

End Sub

Do you mean you have the various tables on different pages? If so you will want to look at storing the variables in some way. Session state, a database or query strings could all work depending on the number of variables you need to carry across to other pages.
One table on one particular page can't directly access what was filled out on an earlier page.
I may have misunderstood your situation though...

Hericles

Thanks Eric,
Worked a treat - although for others that might read this, I needed to go into safe mode to rename one of the folders (not sure why and it may not be the same for everyone).

Hi bas_brain,
I can't help with parts 2 and 3 of your question.
For 1) you can improve the performance by structuring the tables around the data you will be requesting the most. E.g. if there are several columns you will always be selecting and others than you'll use rarely you can split the tables along those lines.
Also, constructing the tables to avoid redundant data is a good idea (have a look and 2nd and 3rd normal forms on the net).

For 4) select * takes everything form the table. This obviously takes longer than just selecting what you actually need.

Hope that helps,

Hi,
I've just had to reinstall Windows XP (again).
It all went well but under Documents and Settings I can see the previous user accounts. Is there some way I can bring them back to life?
I copied all of the files from one of them to a new account but that failed to bring the installed programs across.

Any help?
Thanks,
Hericles

Hi guys,
I have recently installed and configured Apache to process aspx pages (I had to remove IIS when it started using 100% of the CPU when I requested localhost).
Apache works perfectly but I'm having trouble with VS 2003. When I try to create or open a project I get a warning stating that the web server is using version 1.0 of the framework and that the recommended action is to stop and upgade.

But, after having searched around, I can't find any advice on fixing this error. Any advice?

Thanks,
Hericles

Hi,
I'm not a PHP expert but I'm not too bad with MySql. I maybe able to help. Whats the problem?
Steve

I tried that before I posted here but all I get is an Apache error message saying the page cannot be found. I get that message even when Apache is turned off...

Hi,
I recently started reading up on Ruby on Rails and decided to install it so I could give it a go. I found some inconsistencies and problems that I hope I can get some help with.
First, when creating a project I used the ruby script/generate command and it worked fine but when I wanted to start the server I had to use ruby ./script/server (note the ./).
The difference confuses me.
The server then started up on port 3000 but browsing to localhost/3000 did not give me the default Rails page as it supposedly meant to...
Am I missing something simple here?
Thank you,
Steve