Showing Only Null Fields
What to only show the Null fields on an ASP Update form. eg.
<% If "Recordset1.Fields.Item("B15-1").Value" = IsNull then %><input type="text" name="B151" value="<%=(Recordset1.Fields.Item("B15-1").Value)%>" size="32"> ...etc
get what i mean? Needs to be per field - as the exact fields will differ from record to record Any ideas?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Showing Calculated Fields In The Form
I have a asp input form of a financial report. Here most of the fields are text boxes where the user need to input the values corresponding to an item. However, there are few items which are calcuated field. Prior to submission of the information, I would like the user to know what the calculated field be (based on the information input in text boxes) before submission of the form. Is there any way to display the calculated value before submission in ASP?
View Replies !
View Related
Null Fields
I'm extracting some information from a table and some fields maybe be holding null value. i tried doing something like this if rs(VerbalWarning) = NULL then rs(VerbalWarning) = "NULL" else end if it dosent work. How do i display Null values in my output to make it more meaning full.
View Replies !
View Related
.update Creates New Record But All Fields Null
I have made several Access-based CMSs but now I am using SQL Server. I can read the records but my first attempts at writing are resulting in new records (with new ID) but all the fields are null. I am posting the data from a form to the same page and an if /then statement catches the flag in the URL and runs the update script below. All the field names are correct. Code:
View Replies !
View Related
RecordSet (and GetRows) Is Retrieving Null Values When They Aren't Null
I have an interesting situation that needs to be addressed ASAP. I am running a standard SQL Query in ASP to retrieve some rows/columns from a table that's on a SQL Server 2000 database. I put the results of that query into a RecordSet, and then use the GetRows function to push the results that are in the recordset into an array variable. In the query that I am running, 39 columns and 2 rows are returned. The GetRows function appears to be working - the array variable is being created with the proper dimensions. However, the values of the different "cells" of the array are not showing up correctly. The first and the last column values for each row are correct, yet everything else in between is blank, empty, NULL, or whatever. In other words: ArrayVariable(0,0) shows up correctly, ArrayVariable(38,0) shows up correctly, but everything in between is null. I did a test on the RecordSet and discovered that it was the culprit - it wasn't being filled in properly. This is strange, though, because the select query that I run in the ASP code to create the recordset returns perfect results when I run it on the SQL Server 2K database.
View Replies !
View Related
Showing XML
Can anybody help me with displaying two xml content in a asp page. i want it to be shown with collape and expand feature (with those + and - feature when an xml file is opened in explorer). i tried having html frames but i am not able to add menu in the same html page. right now i have menu and two text boxes to display this xml content. i want to use something else instead of text boxes to display xml in indented form. i thought i could use browser component in asp page but it doesnt work.
View Replies !
View Related
Video Showing
I have an active-x control on my asp that loads a wmv video file.But i have a problem viewing the video until i have download the whole video on the active-x control. Is there a way to see a portion of the video without complete download?
View Replies !
View Related
Showing Tif Files
I have a strange problem on WindowsXP proffessional with IE6 ,when i try to display a tiff file ,it is not showing ,small red x is comming up. I tried by dowloading latest IE from microsoft but no use. This is working fine on win2k IE6.Here is the html file I am using to display the tif file. <html> <head> <img SRC="http://192.168.0.30/test/test.tif" BORDER="1"> </head> </html>
View Replies !
View Related
Showing Reminders
I make a intranet Project For a Company.In that Project i make some reminders that can send each other users.When the Reminder come it should be alert like yahoo or Msn means Reminder should be show right side of the Taskbar and it's come like fade.
View Replies !
View Related
New Pages Not Showing Up
i have just uploaded the new files to a website i have rebuilt. I have refreshed IIS and restarted the website but the new files are not showing through on directories that existed before eg subscribe etc. The new directories that didnt exist before work fine but would the internet connection in our office be caching previous pages that are no longer there and trying to access them?
View Replies !
View Related
Showing Records For Each ID
I'm really trying to make this work. I have a dbtabel with following fields. ID PlayerID Date Point I want to show each players point like this "1,2,5,6,4,8,9", but i want the script to first add up which player who has the most points, and then list them in order of wich player who has the most points... 1,3,5,6,4,5,9 2,1,1,3,2,3,6 2,5,6,4,1,1,0 Each row is each PlayerID's row. Is this possible.
View Replies !
View Related
Updates Not Showing
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine. Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS. I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
View Replies !
View Related
Images Not Showing Up
why some of my graphics wouldn't be showing up? I'm using css and everything looks fine in dreamweaver until I upload it then half my graphics are not visible on the page but they are there because I can still click on them, I just cant see them. Any reasons?
View Replies !
View Related
Records Not Showing
I inherited a database driven site, which displays events pulled directly from an access 2000 database. when these events are edited in the admin system, or when a new record is added (again via the admin system), the record will no longer show up as being editable on the choose_event.asp page. I checked the database, and the changes are being made.
View Replies !
View Related
Showing Companyname In URL
ok so I wrote a template based CMS.... A small company requires a website, they come to my site www.mutedesigns.co.uk/sbs and choose a template, pay, register, edit ther details and pages and then view their site simple and it all works yay! Code:
View Replies !
View Related
Showing Shared Dir
I'm working on a Intranet, and found this code to list the contents of a directory. However, the only directory I've been able to show is the dir where the script itself is (Inetpub/Scripts). How can I redirect to a directory somewhere else on the network ? Code:
View Replies !
View Related
Showing Birthdays In ASP
I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth. Using ASP how can I call the access database to show members that date of birth is today. I have the rest of the script but just nedd a SQL statement Code:
View Replies !
View Related
Code Showing
I've been working on a page at work, which has been fine, yet when ive come to try it at home, i load the page (the page loads fine) but i see all the code etc that was hidden before. example what i see at the top of the page: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%<% OPTION EXPLICIT %<% 'dim oCdoMsg, oCdoConfg, st but i see tons more than that, basically all the code to the next %>
View Replies !
View Related
Showing Different Pages (AbsolutePage)
I'm using AbsolutePage to show the results of my recordset in different pages; of course if there is a lot of data, it's gonna show all the links (for example 100 pages, 100 links) So I want to do something like this: pag. 1 2 3 4 ... 97 98 99 100 and of course without showing "..." if there are less than 4 pages. What's the easiest way?
View Replies !
View Related
Showing Records For Each User...
I have a Golf leaderboard based on points given to each player after each match. That works fin, but is it possible to show everys players record after his or hers name. At the time it looks like this. Mike 7,50 Peter 5,45 etc. My code is like this Code:
View Replies !
View Related
Some Data Not Showing In A Form
I am using SQL 2000 database and MS Server 2003. I am pulling in data from a sql table. For some reason, when I include the following line: <tr><td><b><%if rs("Street_dir")<> "" then response.write rs("Street_dir") & " " end if%> <%=rs("Street_num")%> <%=rs("Street_name")%> <%=rs("Street_suf fix")%></b></td></tr> then the following line does not display: <tr><td><%=rs("remarks")%></td></tr> The REMARKS data is blank. But, if I remove the upper address line, then the REMARKS appears. The address is 1111 Main so that does not seem to be the issue. The address information is VARCHAR fields, 255 characters. This works fine on another server where my files used to be, but I just moved to a new server.
View Replies !
View Related
Pictures Not Showing After Upload
I have an upload facility which is working fine. uploads to a folder (photos) through aspsmartupload and database. Ive checked the folder, n database to see if the file is being uploaded and it is. ITs just not being displayed properly on the site. ALl the pictures come up with a little white box with a red cross in it, in the top left had corner.. so its identidied as an image , but its not showing the actual image. .
View Replies !
View Related
Showing All Spaces Without Using The
I am using ASP to read code from a text file that I am displaying on my page. Because I do not want the code from the text file to be executed, I used the Server.HTMLEncode() method to display it as it is in the file. However, the spaces used to indent lines is still removed by the browser. I cannot use VBScript's replace function to replace all spaces with because that would replace all spaces, including ones that I do not want replaced as well as majorly increasing the size of my file. Is there any way to display the spaces used to indent the lines without manually writing a function to do it?
View Replies !
View Related
Showing An Include File
I would like to have the option to show and include file which has a one line table with a red background and printing to pull info out of a SQL database but only if there is data in the table. Basically it is to show breaking news when it happens before there is an article. The SQL table is called breakingnews and the column is called brknews. If the column brknews has nothing in it, I don't want the table to show up on the page but if there is data in it, I want the colored table and text to show up on the page.
View Replies !
View Related
Showing File Extension
If you'll notice, there's a comment in this snippet that drops the extension. How can this be modified so that the extension IS shown? Set myFileSys = Server.CreateObject("Scripting.FileSystemObject") Set Folder = myFileSys.GetFolder(Server.MapPath("/meetings")) for each file in Folder.Files If Not file.name = "index.asp" Then FileName = Left(file.name, (Len(file.name) - 4)) 'drop the extension FileSize = cint(file.size / 1024) 'convert into kilobytes and drop the decimal Response.Write("<li><a href='/meetings/" & file.name & "'>" & FileName & "</a> - " & FileSize & " K<br>" & chr(13)) End If next Set myFileSys = nothing
View Replies !
View Related
Showing An HTML File
Showing an HTML file in part of a Webform.I have a Webform with some buttons on the left side of the form. What I want when clicking one of the buttons is to show an HTML document in a part of the Webform (as if it was a Frame page).
View Replies !
View Related
Showing Default Option
How do I display 'Please Select' as the default value my code is below.Code: <option selected>Please select</option> <%SQLStmt = "SELECT magcode FROM Magazine ORDER BY Magcode" Set rsDistMags = Connection.Execute(SQLStmt) Do WHILE NOT rsDistMags.EOF%> <option value="<%=Trim(rsDistMags("magcode"))%>"<%If Request("magcode") = Trim(rsDistMags("magcode")) Then Response.Write " Selected" End If%>><%=Trim(rsDistMags("magcode"))%></option> <%rsDistMags.MoveNext Loop%> </select>
View Replies !
View Related
Pivot Table Not Showing
I see a similar unanswered post here, I face the same issue.Does Win XP have some bug with Microsoft Office Web Components 11.0 ?I am unable to see a pivot table which I added, in my web page.Strangely enough, this control is showing perfectly in Win 2K with the sameweb page.
View Replies !
View Related
Pages Showing Codes In IE
when i try to view an ASP page in my IE web browser, all i see are the codes used to design the page but when i preview 'em in Dreamweaver its okay.Why is it so ?does it mean if i publish my asp pages to the web; thats how they'll be on other people's browsers ?what do i do to be able to see the actual web page and not the codes in an ASP page.
View Replies !
View Related
Dynamically Showing Datediff
I have a datediff comparision value on my form. Since one of the dates inside the datediff is: now(), I'd like to know if there's a way to show the result dinamically (without reloading the page..). I can't see how to do it from server side...It's possible to use js to fill the field or reload only the field value? detail: I'll need to submit the current diftime value along the other input values on my form at the end of process.
View Replies !
View Related
Without Record - Page Not Showing Up
I have an ASP page in a table style (heading and data). At the beginn of each month (actually only the first day) there is no data in my database and so-with nothing to show up on the ASP page. If I would like to open the ASP page over the net IE is telling me that it cannot find my page. Is it possible that, even if there are no records to show, at least the heading is shown on the Internet?
View Replies !
View Related
Showing HTML As Text
I am sending out an HTML email using CDOSYS and want to include some HTML code within the text of the email. So, it's something like: Hi Your link is <a href="www.domain.com/subfold">Link</a> But it includes the code within the HTML. How do I just show it as it's written?
View Replies !
View Related
Showing Files In A Folder
Am developing a website, thats only allows user with permission to acces certain file. What I have is a webpage that list all different projects available. When a user clicks on a project, he is asked to enter username and password. If succesful the user is then taken to a webpage displaying all files available to download for that particular project. Note: All the files asssociated with particular project are in necessary folder. So project London, has a folder called london with all its files in that folder. How do I get all the files displayed on the webpage for that particular project?
View Replies !
View Related
Showing Only X Number Of Characters
I am using a WYSIWYG editor for articles and the article text is being inserted into a SQL db field called ARTICLEBODY. Question: On my homepage, I only want to display the first 400 characters of ARTICLEBODY field. I am using the LEN function and it does what I want. BUT, is there a way to not have it cutoff in the middle of a word?
View Replies !
View Related
Images Not Showing When Include Navbar
I have an application that has many different look and feels(?) based on the client. Currently my site uses frames with top_navbar appearing in the top (which appears based on the stylesheet of the client) The main frame houses the welcome page which is stored in a directory relating to that client) or other pages stored in a generic directory (VC) which holds all pages that are common to all clients. In this directory is an IMAGES directory which strangely holds all client's images together....there are some common ones...thats prob why its done like that. In order to improve the accessibility of the site, I decided to do an include of the top_navbar, to get rid of frames. This works fine when included in the welcome page as the file paths to the images is correct, but when i do it to from a page that is held in the generic directory (VC) the image path is obviously not now correct. My question is this...How can i get top_navbar to check where it is before setting the filepath to the images? Is this possible?
View Replies !
View Related
Sending Emails And Showing Progress
I need a way to show the client that the emails are being sent and how many are left. The way I want to do this, is by opening a window which will send the emails and display the status. The problem is how do I pass it the subject, body and so on. I don't want to use a querystring. I thought of doing it like so: onSubmit = progress() - this will call a js script which will open the progress window action = (the page that gets all the values from the form and sends the email) Is there a way to update the popup window from the "action" page? for example: everytime an email is sent... increase a variable and send it to the popup window, and then close it when its done.
View Replies !
View Related
Why Are My HTML Tage Showing In EMAIL?
When I send this code (using CDONTS) I had expected just the title to appear on the email but ALL of the text - including the HTML tags are coming though. Do I need a line setting something to HTML so it knows it's HTML? Any ideas??? CODE IN QUESTION: Body= Body & "<HTML>" Body = Body & "<HEAD>" Body = Body & "<TITLE>Send Mail with HTML</TITLE>" Body = Body & "</HEAD>" Body = Body & "<BODY bgcolor=""lightyellow"">" RESULTING EMAIL: <HTML><HEAD><TITLE>Send Mail with HTML</TITLE></HEAD><BODY bgcolor="lightyellow">
View Replies !
View Related
IIS5 Not Showing ASP Files, Shows Others
Annoying problem on a server with IIS 5. [We have other IIS 5 that show asp files just fine. I'm at a loss. ] I can open htm, html, gif, jpg, all files except asp files. The message when opening an asp file is: "The page cannot be found... blah blah blah HTTP 404 - File not found" I've looked everywhere. Permissions are okay with IUSR and security since we can browse other files. The asp files in question are NOT marked Hidden... What can I do to make it render the asp files? Ideas?
View Replies !
View Related
Showing Password In Encrypted Form In SQL
I have seen one table in which while selecting records from that table and viewing the resultset in Grid format the passwords was coming in encrypted form means suppose the password was 'super' but in the resultset set it seen as n or some other letter. But if the same resultset was viewed in Text format then the actual password was seen...
View Replies !
View Related
Access Tables Not Showing Up In Dreamweaver
I have the following connection string: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../_database/MOO_ACCESS.mdb") & ";" Which tests successfully. When I try to view the tables within Dreamweaver of the access database though, it shows none. There are definitely 2 tables built in the database. anyone have any ideas?
View Replies !
View Related
Showing An Image From A Database Problem
I have a test table Named Pictures with only one column which is named Picture and the data type obviously is set to 'Image', now i have no problem inserting an image into the database... Now i wish to simply show the picture. The way in which i am doing this is by dragging a grid view on to the web form. Now when i load up the page i get the below error:- "The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content. " It doesn't matter if i has anything in the table or not, i get the same error. Is this because i can't just directly show the image through a gridview or wot?
View Replies !
View Related
Showing An ASP Page As A Continuing Data Table
I would like to show my data in a ASP table. I do not want a sort of record selector on that page. So I did the following: Please be as kind and look the attachment I would like to see a table header like "tradeid,clearingnumber" etc - and underneath the list of records. can someone tell me how to get this because in the moment I only see one record always it's not continuing writing the list.
View Replies !
View Related
Include Files Not Showing In Design View - WHY?
I have 2 include files on my page which are both navigation bars. When i view my pages in IE they look fine and everything is in the correct place, however the problem is that when i look at the pages in design view in Dreamweaver i can only see my first include file. the rest of the page is not displayed so makes designing hard as i cant really see what i am doing until i view my page in IE. WHY IS IT DOING THIS???????????????? Or is this meant to happen, i have never used include files before, but im assuming this shouldnt happen?
View Replies !
View Related
Showing UNICODE (Chinese) From SQL Server On An ASP Page Using Dreamweaver
I have a simple ASP form in which I am reading and showing the data from SQL Server database. This database has a nVarchar field, which stores some data in Chinese language. When reading and printing the data using a SELECT query it shows ??? (Question Marks) instead of the Chinese data. I have checked using Query Analyzer that the data is correctly stored in Chinese only. I have looked up for this problem and it looks like many have faced the same before. But the only solution which seems to be provided for this is using the FORMS 2.0 controls, because VB converts the Unicode to ASCII and that corrupts the data. But is there any other solution to this? I am using Dreamweaver to write the ASP pages. Dreamweaver is capable of showing the Unicode data, but can’t do much if it gets corrupted data from the VB itself. So Please any help will be highly appreciated. That’s the sample code which I am using if it helps: .....
View Replies !
View Related
|
TRACKER
