Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: aarellano
  • Content: Threads
  • Order by date
  1. aarellano

    if statement to resolve sql depending on user id

    Hello, I have an asp page that checks the user id, then goes to an acces db to check user credentials, if the user gets authenticated, the user gets redirected to see his data only. This works well. I am trying to ad an admin user. To be able to see all the records here is what my code...
  2. aarellano

    declare a variable

    Hello, I have a couple of declared variables mo= rs("month") dy= rs("day") dpt= rs("dptno") tbc= rs("tbcod") runlab = rs("runlabor") what I am trying to do now is to declare a new variable with an if statement I have tried hrs = if tbc= 3 then runlab/1000 elseif tbc=4 then runlab/10000...
  3. aarellano

    error when thre is no data

    Hello, I have an asp page that loads dynamic data from one of my servers. In the morning when there is no data in the file when I call my asp page I get the following error Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested...
  4. aarellano

    Create Date and Last Open Date

    Hello, I am triying to insert a create date in a form when the form is created and a open date when the form was last oppened. I have tried Date() but it changes everytime to the current date. Any suggestions are greatly appreciated!!!!
  5. aarellano

    if statement

    Hello, I have an asp page, that builds an xml file. I would like to insert an if statement but it does not seem to be working. I am not really sure what i am doing wrong any help is always appreciated!!! Here is my code mo = rs("mo") dddpva = rs("dddpva") act.WriteLine"<item month="""...
  6. aarellano

    Windows Server 2000 IIS goes down when connected to LAN

    Hello I would really appreciate some advice!! I have a Windows 2000 server with IIS. The server has two nics one for the Lan and one for the WAN We are using it as a webserver just for our reps. Everything was working well and all of the sudden if the server is connected to the LAN nobody can...
  7. aarellano

    newbee to xml odbc connection?

    Hello, I am completly new to xml. I dabbled a little with asp. and know how to get dynamic data from an odbc connection to an asp page. Does xml work in the same way or do you need to embed it into a asp or asp.net page? I have looked around but have to really found anything that really tells...
  8. aarellano

    syntax error

    Hello, I have an asp page that displays an xml output asp code act.WriteLine("<month>" & rs("month") & "</yr>" ) this displays <month>05</month> {/code] I would like to display <item month="05" value="1.2" /> I tried [code] act.WriteLine("<item month= >" & rs("yr") & "<value= >" &...
  9. aarellano

    Drag and Drop

    Hello, I am trying to add a drag and drop to a data grid and to a chart. I have found many examples that show how to move the data itself but not the whole grid or the whole chart. Could anybody point me in the right direcction?? Thank you!!!!
  10. aarellano

    cross tab query

    Hello, I have a sql statement that creates like a corsstab query. select mainf.gel.gln, sum(case mainf.gel.gltyp when 1 then mainf.gel.pdr05-mainf.gel.pcr05 else 0 end) MayCurrent, sum(case mainf.gel.gltyp when 2 then mainf.gel.pdr05-mainf.gel.pcr05 else 0 end) MayBudget from mainf.gel...
  11. aarellano

    embed user name and password on a link for asp page

    Hello, I created a report in asp, was able to create a login and now I am wondering if there is a way to embed a user name and password for an asp page. I looked and some suggestions were for example http://username:password@website.com/reports This does not work. any help is truly...
  12. aarellano

    Set Date to delete items on Mailboxes

    Hello All, I have been asked to delete items in the inbox if they are older than 60 days and to clear the deleted items and sent items every 30 days Is there a way to acomplish this?
  13. aarellano

    Newbee formating error??

    Hello, I just started learinig flex, I came across a flex for dummies book. they give an example of two buttons <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"/> <mx:HBox /> <mx:Button label="Button1"/> <mx:Button...
  14. aarellano

    moving an object on mouseclick

    Hello, I came across a script where you can move an object, and that works very well, I am wondering if there is a way to move the object on a mouse click? Here is the script I am using <head> <style> <!-- .dragme{position:relative;} --> </style> <script language="JavaScript1.2"> <!-- var...
  15. aarellano

    workstations getting disconnected from the gateway

    Hello, Recently I gave sonicwall a call, because I had an issue with my subnets. We fixed the issue. Now what is happening is that some of the work stations in the network can ping our main server and all of the other computers in the location, but cannot ping the gateway (sonicwall tz170)...
  16. aarellano

    #5.5.0 smtp;530 Authentication required

    Hello, All of the sudden I am getting bounced back emails with the following. #5.5.0 smtp;530 Authentication required I have not changed anything on my exchange server, any idea what this might be??
  17. aarellano

    compare elements of one table multiple times

    Hello, I have a table called pr, this table consists of two fiels, parent and child. the parent can have a child and the child can be a parent as well, this can happen multiple times so I was trying to put the same table multiple times and joining the parent to the child of the next table. for...
  18. aarellano

    Multiple records update

    hello, I build a form to be submited. in the form each user can enter their information. But it gets processed at the end of the day after all the info has been verified. Right now I can do a submit for each of the users, is there a way that I could submit all the users at once. right now I...
  19. aarellano

    Recordset.MoveNext returs records twice

    Hello, I have an asp script that returns different record. The problem that I am having is that the script returns the same record twice. here is what my code looks like 'Dimension variables Dim adoCon 'Holds the Database Connection Object Dim rsGuestbook 'Holds the...
  20. aarellano

    asp variable into xml code

    hello, I am starting to learn XML. I know a bit of asp. In asp you can connect to a db and get different fields from the db. Is there a way to do the same with XML?

Part and Inventory Search

Back
Top